Too many pages

[Guest]

I have an Excel document that I use each month. The data covers about 10
pages each month but somehow along the way thhe document has grown to be
about 300 pages. That is, there's nothing on about 290 pages but if someone
starts to print the whole document, 300 pages begins to print.

How can I delete these excess blank pages?

Thanks, Richard

 

[Guest]

Select the first page you don't need with the tabs. Use the button to get you
to the last page in the workbook, hold select and select that tab. Right
click and select delete.

Hope that helps

 

[Peo Sjoblom]

http://www.contextures.com/xlfaqApp.html#Unused

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Gord Dibben]

You can reset the print range to cover just the 10 pages.

File>Print Area>Clear

Select your area then File>Print Area>Set

Also, you can reset what Excel thinks is the "used range"

See Debra Dalgleish's site for instructions on resetting the used range of a
worksheet.

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


Gord Dibben MS Excel MVP