HOW DO I GET RID OF BLANK PAGES?

slangbert · May 7th, 2002, 03:51 PM

I have a workbook with 7 pages of info. When I use Print Preview it shows 14 pages, the last 7 of which have no data on them. When I use Page Break Preview, it shows only 7 pages. How do I get rid of the 7 blank pages so when I print I do not waste paper (7 extra pages with just the header/footer)? Any help is greatly appreciated.

rdeters · May 7th, 2002, 03:56 PM

It seems like you may have pages indicated after page #7. Go to 'view' then 'page break preview', scroll to the bottom of the last page and try pulling down the page seperator, you'll probably find that there are more pages there, just delete them.

Jack in the UK · May 7th, 2002, 04:04 PM

suggest using page break view and zoom to smaller size say 50 % easier to see see if you have any data in the odd 7 pages if not delete them

if you have not see this before the blue lines outline each page

James · May 7th, 2002, 04:12 PM

Hi Slangbert,

You may want >File>Page Setup>Sheet and see
what is in the "Print Area"

James

May 7th, 2002, 04:04 PM	#3
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	suggest using page break view and zoom to smaller size say 50 % easier to see see if you have any data in the odd 7 pages if not delete them if you have not see this before the blue lines outline each page __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 7th, 2002, 03:51 PM	#1
slangbert New Member Join Date: Apr 2002 Posts: 7	I have a workbook with 7 pages of info. When I use Print Preview it shows 14 pages, the last 7 of which have no data on them. When I use Page Break Preview, it shows only 7 pages. How do I get rid of the 7 blank pages so when I print I do not waste paper (7 extra pages with just the header/footer)? Any help is greatly appreciated.

May 7th, 2002, 03:56 PM	#2
rdeters New Member Join Date: May 2002 Location: Calgary, Canada Posts: 40	It seems like you may have pages indicated after page #7. Go to 'view' then 'page break preview', scroll to the bottom of the last page and try pulling down the page seperator, you'll probably find that there are more pages there, just delete them.

May 7th, 2002, 04:12 PM	#4
James Board Regular Join Date: Feb 2002 Location: Huntington Beach, CA USA Posts: 327	Hi Slangbert, You may want >File>Page Setup>Sheet and see what is in the "Print Area" James