Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) | |||
Print a sheet area to another... | Excel Discussion (Misc queries) | |||
set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) |