Sara

Find the bottom row of your actual data range.

Select row below and SHIFT + END + DownArrow.

EditDeleteEntire Rows.

Same for columns to the right of data.

NOW! IMPORTANT!! Save the workbook, close and re-open to see difference in
used range.

Debra has this same method on her pages.

Gord

On Tue, 7 Dec 2004 14:49:02 -0800, "Sara"
wrote:

Gord-
I went to the site, but she said that if there are merged cells (which there
are), then her code wouldn't work (which it didn't). Is there ANYTHING else I
can do to get rid of these extra pages?!
Thanks for your time,
Sara

"Gord Dibben" wrote:

Sara

For complete instructions on re-setting the actual used range see Debra
Dalgleish's site.

http://www.contextures.on.ca/xlfaqApp.html#Unused

Gord Dibben Excel MVP

On Wed, 1 Dec 2004 08:51:03 -0800, "Sara"
wrote:

I made a spreadsheet that is 6 pages long. However, I accidently set
something on the down arrow and scrolled down a LOT. Now, the spreadsheet
still takes up only 6 pages, but when i print the document, it shows that it
is 50 pages long! I know how to go in and limit my printing to pages 1-6, but
other people have access to this document, and I don't want them to end up
with 50 pages of empty cells if they're not paying enough attention. How can
I delete these extra pages?