how do I print grid lines for blank rows

[Guest]

I'm trying to create a log-in sheet with titles in the top row and then blank
rows the rest of the page which can be manually filled in. I cannot figure
out how to print the grid lines for the blank rows. Thanks for any
suggestions.

 

[Guest]

Go to cell A53 (or so). Hit the spacebar once. This is enough to make Excel
think that the worksheet ends at row 53. It will now print down to row 53.
Make sure you have 'Gridlines' checked in the Print Setup.
HTH,
Gary Brown

 

[Guest]

That sounds like a brilliant solution. And so simple. Thanks. Gail Rolfe

 

[Myrna Larson]

Hmmm.... I found that if I set the Print Area to include those blank cells
at the bottom, and turn on printing of gridLines, I get what you are asking
for.