Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim May
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print all charts in a workbook (multiple worksheets) aewsaws Charts and Charting in Excel 4 May 12th 23 03:45 AM
Identify repeated cell entries in multiple sheet workbook as you . Trigger Excel Discussion (Misc queries) 0 August 17th 05 01:57 AM
Print a sheet area to another... Mike Excel Discussion (Misc queries) 5 July 8th 05 09:05 PM
set the print area print multiple tabs veng Excel Discussion (Misc queries) 5 February 12th 05 07:01 PM
Multiple Worksheets and Print Merge function pfe Excel Discussion (Misc queries) 2 December 2nd 04 11:23 PM


All times are GMT +1. The time now is 04:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"