How do I get rid of mysterious blank rows in Google Docs spreadsheet? (Need answer fast)

Factual Questions
1

I have a spreadsheet right now that someone else created that I’m trying to clean up. I know how to do these things in Excel but not in Google Docs. I need to top-align all the cells/rows/columns/whatever you want to call them. How do I do this? It doesn’t seem obvious from the Help section.

Your assistance is much appreciated.

Side note: what might cause extra blank rows to show up when printing, that don’t show up when viewing the spreadsheet online? Any ideas? These are the two problems I’m trying to help fix.

2

Edit: I figured out the top-align thing. Now I just need to figure out why it’s printing a blank row between some entries, always at the top of a new page, underneath the first row after the headers…

3

The blank cells: I would check the Print Area and also what is defined as the Header in the Page Setup dialogue. Also look for a Page Break that doesn’t belong. Other than that, I got nothing.

4

Thanks Sparky, I will try to find those settings.

5

[moderating]
Thread title changed from “How do I top-align cells in Google Docs?” to “How do I get rid of mysterious blank rows in Google Docs spreadsheet?” at the OP’s request.
[/moderating]

6

Oops! I’m sorry, I read that as being an Excel file :smack:

7

[quote=“Gary “Wombat” Robson, post:5, topic:586430”]

[moderating]
Thread title changed from “How do I top-align cells in Google Docs?” to “How do I get rid of mysterious blank rows in Google Docs spreadsheet?” at the OP’s request.
[/moderating]
[/QUOTE]

::bows to you:: thank you for making that change. I know it was quite a 180 from the original.

8

Yeah I can’t find anything like those settings in Google Docs :frowning:

9

Do the blank cells appear when printing to paper or when generating a pdf (or both)?

10

Both. I stopped printing on paper to save paper, and am just going based off what the pdf looks like for now, since the paper version always looks just like the pdf.