ExcelBanter - View Single Post

Mike Copeland

In article , says...
I'm trying to create a worksheet for manual entry via Excel, and
although I clicked the Gridlines box in Page Setup/Sheet, the only
gridlines that print are around lines that contain content (at this
time only the title row). I know that I can print all lines & cells
with gridlines, but I don't know how. Please advise. TIA

You will print gridlines when you have rows with content. Blank cells
included!

I'm trying to replicate a "form" that I've been given: it's a page
that has no content except for the header row. Somehow this Excel
spreadsheet has been created so that even though all rows are empty, all
rows on the page print. (The form is meant to be filled in manually...)
All I have to work from is the printed sample page.
Is there some way an Excel file can be created with non-displaying
"dummy rows" that print the sheet's gridlines even when they're "blank"?
(Or is there some other sort of "trick" at play here?) TIA