HOW DO I GET RID OF BLANK PAGES?

slangbert

New Member
Joined
Apr 4, 2002
Messages
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.
 

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
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.
 
Upvote 0
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
 
Upvote 0
Hi Slangbert,

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

James
 
Upvote 0

Forum statistics

Threads
1,214,391
Messages
6,119,249
Members
448,879
Latest member
oksanana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top