Multiple Print areas in same sheet?
 

I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas that I
can access by using the box at the top left, and I also want to be able to
print them directly (via the print icon) as opposed to using
'file-print-selection'

Any ideas?

Thanks,

Enzo

hi,
by default, you can only have 1 print area at a time per sheets. but you can
do what you want. just write a print macro which you can do on record. for
each print area you wish, while on record, set the print are, headers and
footer is needed. do this for each area of the sheet that you wish to print.
this way you could assgn each print macro to a button or all macros to the
same button.

Regards
FSt1
"Enzo" wrote:

I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas that I
can access by using the box at the top left, and I also want to be able to
print them directly (via the print icon) as opposed to using
'file-print-selection'

Any ideas?

Thanks,

Enzo

Enzo wrote:
I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas that I
can access by using the box at the top left, and I also want to be able to
print them directly (via the print icon) as opposed to using
'file-print-selection'

Any ideas?

Thanks,

Enzo

Look at the "Custom Views" topic in the Help.

"Views" allow you to setup multiple ways of seeing and printing your
worksheet

Select your areas on your worksheet (they can be discontiguous), then
file|printarea|Set print area

Be aware that when you print this kind of discontiguous range, each area in the
print range will start on a new piece of paper.



Enzo wrote:

I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas that I
can access by using the box at the top left, and I also want to be able to
print them directly (via the print icon) as opposed to using
'file-print-selection'

Any ideas?

Thanks,

Enzo

--

Dave Peterson

In 2003 there is the ability to Copy a range, then BEFORE Pasting it to a
centralized Print area,, hold down the shift key and click on the Edit menu
and select "Paste-Picture-Link"
Continue to Copy and Paste_Picture-Link to accumulate all your ranges on the
one sheet (for printing);
Changing the original data (whereever it is) immediately
changes your linked Print area.
HTH

"Zarqy" wrote in message
oups.com...

Enzo wrote:
I need to create a number of print areas in the same sheet within my
spreadsheet. Just to clarify, on sheet1 I need 3 different print areas
that I
can access by using the box at the top left, and I also want to be able
to
print them directly (via the print icon) as opposed to using
'file-print-selection'

Any ideas?

Thanks,

Enzo

Look at the "Custom Views" topic in the Help.

"Views" allow you to setup multiple ways of seeing and printing your
worksheet