Cool. that will work better. Entering a space where we want to stop!

Thanks. I posted YES this helped.

"Gord Dibben" wrote:

A whole sheet of blank rows?

You sure you want to print that many pages?

Let's say you want to print A1:H100 with only row 1 having data(titles)

Pre-select A1:H100 and set that as your print range.

Or................

In H100 enter a space character.

Now Excel will see your print range as A1:H100


Gord Dibben MS Excel MVP

On Mon, 15 Mar 2010 09:39:01 -0700, Bud
wrote:

Hello

I am using excel 2007 and want the gridlines to show up for the excel
worksheet when it is printed (all 8 columns and a whole sheet of blank rows).

I already went to Page setup and SHEET and selected GRIDLINES. I also have
Draft quality unchecked.

It is ONLY printing the heading line(1st line) and NOT any other gridlines.

We want to use the spreadsheet to print the lines and fill in by pencil what
we want in the various columns and rows.

If we fill down a date in the first column rows it will print all the
gridlines in all the columsn for us to fill out all the information for every
row in which we included the date.............but we want to see all the
gridline columns and rows without filling in a date.

Thanks for any help

.