R
Raz
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.
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.