how do I print grid lines for blank rows
 

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.

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


"gailrolfe" wrote:

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.

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

"Gary Brown" wrote:

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


"gailrolfe" wrote:

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.

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.


"gailrolfe" wrote in message
...
That sounds like a brilliant solution. And so simple. Thanks. Gail
Rolfe

"Gary Brown" wrote:

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


"gailrolfe" wrote:

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.