Thread: Too many pages
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default Too many pages

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

FilePrint AreaClear

Select your area then FilePrint AreaSet

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

On Fri, 9 Jun 2006 11:22:02 -0700, Serengetti
wrote:

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