Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How Do I Delete Blank Pages of a Spreadsheet
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How Do I Delete Blank Pages of a Spreadsheet
Arbee5 wrote:
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. Check your margins. gls858 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How Do I Delete Blank Pages of a Spreadsheet
Thanks....I have checked my margins, highlighted the extra pages...pressed
delete several times, and still have all 5 pages.... "gls858" wrote: Arbee5 wrote: 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. Check your margins. gls858 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How Do I Delete Blank Pages of a Spreadsheet
View 'Page break preview'
Drag the bright blue borders to remove the pages you don't need. View 'Normal'. George Gee "Arbee5" wrote in message ... Thanks....I have checked my margins, highlighted the extra pages...pressed delete several times, and still have all 5 pages.... "gls858" wrote: Arbee5 wrote: 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. Check your margins. gls858 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How Do I Delete Blank Pages of a Spreadsheet
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 :-) ------------------------------*------------------------------*---------------- "Arbee5" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I delete extra (blank) pages in excel??? | Excel Discussion (Misc queries) | |||
How do I delete blank pages? | Charts and Charting in Excel | |||
How do I delete extra blank pages from an excel worksheet? | Excel Worksheet Functions | |||
Can't delete blank pages | Excel Discussion (Misc queries) | |||
How do I delete extra blank pages at end of doc...only show when. | Excel Discussion (Misc queries) |