Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
how to have multiple print area on the same worksheet and print one that
needed only? I have a spreadsheet with 5 sections. I need to have 5 different print area. and according to entries in another worksheet I would need to print only one of them. also need to have page break (vertical) at specific locations. First of all is this possible??? here is what I have in my worksheet. top 5 rows are frozen (freezzing pane) First Section: A6 to N13 (vertically for 2 pages) Need page break at A50 Second Section: Q6 to AC16 (vertically for 2 pages) Need page break at A50 and so on. Need to print only one of four sections, according to entry on another sheet say if A1="One" i would print First Section, if A1="Two" i would print Second Section and so on. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
copy print area to multiple worksheets | Excel Discussion (Misc queries) | |||
setting page setup/print area for multiple sheets | Excel Discussion (Misc queries) | |||
How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) |