How Do I Delete Blank Pages of a Spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a spreadsheet consisting of 3 pages, however, in print preview and
when printed, there are 2 extra, blank pages at the end of the document.
They print blank....how do I DELETE these two extra pages without just
highlighting the ones I want and command print? Any help would be
appreciated.
 
Arbee5 said:
I have a spreadsheet consisting of 3 pages, however, in print preview and
when printed, there are 2 extra, blank pages at the end of the document.
They print blank....how do I DELETE these two extra pages without just
highlighting the ones I want and command print? Any help would be
appreciated.
Click to expand...

Check your margins.

gls858
 
Thanks....I have checked my margins, highlighted the extra pages...pressed
delete several times, and still have all 5 pages....
 
View > 'Page break preview'
Drag the bright blue borders to remove the pages you don't need.

View > 'Normal'.

George Gee
 
Sounds like Excel believes there is more to your data than meets the eye.
Select all the columns to the right of your data and press "CTRL" + "-" at
the same time which will physically delete the columns (They will be
replaced but they will definitely be empty). Now do the same to the rows
below your data.

Finally just for good measure, you can select the area you want to print and
do File / Print Area / Set Print Area and that should be the last time you
have to do it.

Then just hit Print.

The easy way to check where Excel believes your data ends is to hit "CTRL" +
"END" and often you will find that it is way out past where you thought your
data finished.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------
 
Back
Top