And you *only* have to put that zero length string in the bottom, right-most
cell of the desired print range, and then:

<File <Page Setup <Sheet tab,
and click on "Gridlines", then <OK.
--
Regards,

RD
----------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------------

"Ed Cones" wrote in message
...
Good tip. Thanks. Never thought of that to see what's in the cell.

"Dave Peterson" wrote:

Another option...

I don't like using the space character for this. It's too hard to see
when you
want to clean things up.

I like using a formula:
=""

The cell still looks empty, but the formula will display in the
formulabar--and
usually it's enough to remind me why I did it.

Ed Cones wrote:

My solution is not elegant, but it's very simple.

Just hit the spacebar on each cell in the top row. Excel will print
the
column, complete with gridlines, if there's anything in any row -- even
a
space.

"ctrbeth" wrote:

I am new to excel. It is so confusing. I am trying to figure how to
print up
a blank spreadsheet with blank cells. If I leave the cells empty, the
gridlines do not print. Only the cells with text in them show
gridlines when
printed. I am trying to make a sign-up sheet where people can sign it
with a
pan, but the gridlines don't print up. Help

--

Dave Peterson