| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many pages to print off
I have a large spreadsheet that I have a macro set up to sort information . When I do a print preview it shows 8 pages of information (which is what I want) and another 8 pages of nothing. How do I prevent Excel from printing off the extra pages? My page break setup is only showing the 8 pages. All looks good to me. -- danc ------------------------------------------------------------------------ danc's Profile: http://www.excelforum.com/member.php...o&userid=31339 View this thread: http://www.excelforum.com/showthread...hreadid=522439 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too many pages to print off
When I do a print preview it shows 8 pages of information (which is
what I want) and another 8 pages of nothing. How do I prevent Excel from printing off the extra pages? My page break setup is only showing the 8 pages. All looks good to me. Maybe this will help: File Page setup Page Scaling Fit to “1” page wide by “8” tall |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Too many pages to print off
Select all that you want to print and then go to file, print area and
click set print area. If you save the spreadsheet the print area you have set will also be saved. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I set my workbook up to print only first 2 pages? | Excel Discussion (Misc queries) | |||
| Print pages in a different order | Excel Discussion (Misc queries) | |||
| Print Odd/ Even or specified pages in excel at a time. | Excel Discussion (Misc queries) | |||
| Print Odd/ Even or specified pages in excel at a time. | Excel Discussion (Misc queries) | |||
| print different row titles in one sheet w/ many pages | Excel Worksheet Functions | |||
Hybrid Mode
