Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You can define your print area to be something other than a rectangular block
(in your example, A1:BG100)--or even discontinuous ranges--by using the CTRL key. First hightlight A1:M100. Then hold the control key while you highlight N1:BG25. Then set your print area. "JBoyer" wrote: In my worksheet Column A:M (which fit on one page) go down around 100 rows, then from N:BG (which is three pages) only use about 25 rows So basically if I would hit print It would print 12 pages, 6 of which would be blank. I would like to set it up so that it only prints the pages with data, and preferably save it that way so I will not have to make the changes everytime I print. Hope someone can understand this and can help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My excel spreadsheet won't print or print preview all the pages? | Excel Worksheet Functions | |||
Can't print 3 pages of a workbook,it will only print one | Excel Discussion (Misc queries) | |||
Print Area ranges print on separate pages? | Excel Discussion (Misc queries) | |||
need a print macro to print only a certain number of pages | Excel Discussion (Misc queries) | |||
How to print odd pages and even pages seperately in Excel. | Excel Discussion (Misc queries) |