Blank pages are overwhelming my worksheet!

I have a six-page spreadsheet that suddenly has a ton of pages (seven extra
for each) tacked onto the end of it. When I go to Print Preview, what I'd
like to be the last page of my document says "Page 6 of 42." Unless I specify
to print only pages 1-6, I get 42 pages total, with a header on top of each.
At first I thought it was a problem with the Page Order in Setup--I have it
set at "Down, then over," but switching it to "Over, then down" just inserts
the blank pages between each of my six. I also can't seem to select and
delete the blank pages without also selecting the pages I need to keep.

What is wrong with the setup for this file? Any ideas? Thanks in advance!

You could select the range of cells you wish to print and then set a print
range. But I would take a guess though that there is cell formatting in cells
that contain no data, this will cause Excel to print those extra pages. You
can select the suspected cells and clear all formats from them that sholud
fix you problem

"Carrie Downes" wrote:

I have a six-page spreadsheet that suddenly has a ton of pages (seven extra
for each) tacked onto the end of it. When I go to Print Preview, what I'd
like to be the last page of my document says "Page 6 of 42." Unless I specify
to print only pages 1-6, I get 42 pages total, with a header on top of each.
At first I thought it was a problem with the Page Order in Setup--I have it
set at "Down, then over," but switching it to "Over, then down" just inserts
the blank pages between each of my six. I also can't seem to select and
delete the blank pages without also selecting the pages I need to keep.

What is wrong with the setup for this file? Any ideas? Thanks in advance!

Hi Carrie

Reset your usedrange, look on Debra's site
http://www.contextures.com/xlfaqApp.html#Unused


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Carrie Downes" wrote in message ...
I have a six-page spreadsheet that suddenly has a ton of pages (seven extra
for each) tacked onto the end of it. When I go to Print Preview, what I'd
like to be the last page of my document says "Page 6 of 42." Unless I specify
to print only pages 1-6, I get 42 pages total, with a header on top of each.
At first I thought it was a problem with the Page Order in Setup--I have it
set at "Down, then over," but switching it to "Over, then down" just inserts
the blank pages between each of my six. I also can't seem to select and
delete the blank pages without also selecting the pages I need to keep.

What is wrong with the setup for this file? Any ideas? Thanks in advance!