| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prints too many pages
Hi,
I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? Thanks, Mickey |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prints too many pages
Mickey
GotoviewPage break Preview, Drag the blue lines to the area you want to print. Or gotoFileprint areaclear print area, then select what you want to print and go back and "set print area". Mike Rogers "Mickey" wrote: Hi, I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? Thanks, Mickey |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prints too many pages
Even if I delete the header 2 pages print. What am I doing wrong?
Thanks "Mike Rogers" wrote: Mickey GotoviewPage break Preview, Drag the blue lines to the area you want to print. Or gotoFileprint areaclear print area, then select what you want to print and go back and "set print area". Mike Rogers "Mickey" wrote: Hi, I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? Thanks, Mickey |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prints too many pages
Page Setup/ Page/ Fit to 1 page wide by 1 tall ?
-- David Biddulph "Mickey" wrote in message ... Even if I delete the header 2 pages print. What am I doing wrong? "Mike Rogers" wrote: Mickey GotoviewPage break Preview, Drag the blue lines to the area you want to print. Or gotoFileprint areaclear print area, then select what you want to and go back and "set print area". "Mickey" wrote: Hi, I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prints too many pages
I already have it set up that way. Any other suggestions? Thanks
"David Biddulph" wrote: Page Setup/ Page/ Fit to 1 page wide by 1 tall ? -- David Biddulph "Mickey" wrote in message ... Even if I delete the header 2 pages print. What am I doing wrong? "Mike Rogers" wrote: Mickey GotoviewPage break Preview, Drag the blue lines to the area you want to print. Or gotoFileprint areaclear print area, then select what you want to and go back and "set print area". "Mickey" wrote: Hi, I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prints too many pages
Do you have contents in your last column that overflow from that column to
subsequent columns? You could try turning on wordwrap for the last column (or setting it to align from the right, not from the left). -- David Biddulph "Mickey" wrote in message ... I already have it set up that way. Any other suggestions? Thanks "David Biddulph" wrote: Page Setup/ Page/ Fit to 1 page wide by 1 tall ? -- David Biddulph "Mickey" wrote in message ... Even if I delete the header 2 pages print. What am I doing wrong? "Mike Rogers" wrote: Mickey GotoviewPage break Preview, Drag the blue lines to the area you want to print. Or gotoFileprint areaclear print area, then select what you want to and go back and "set print area". "Mickey" wrote: Hi, I have a spreadsheet with a header. I have it set to print only pages that have text. Even though only 1 page has text it prints 2 pages (the 2nd page just has the header). How can I prevent it from printing the extra page? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I keep heading so it prints on multiple pages | Excel Discussion (Misc queries) | |||
| In an excel document the info n row 2 prints out on both pages? He | Excel Discussion (Misc queries) | |||
| ½ symbol prints a 2 and Winding square box prints a F | Excel Discussion (Misc queries) | |||
| I have too many columns and rows, so it prints too many pages. | New Users to Excel | |||
| My scaling is set to print 1x1 pages. But it prints 1000's of page | Excel Worksheet Functions | |||
Hybrid Mode
