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
|