Hi Gord Dibben

If I set a space at 100 and than someone else wants 50 how do we reset to 50.

I tried to hit the delete key in 100 and than put a space in 50 but it still
took the 100

Thanks

"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

.