If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How can I print multiple pages onto one sheet in Access 2003 ? | Stacey M | General Discussion | 1 | September 22nd, 2005 12:38 AM |
Set Multiple Print Areas | James Hamilton | General Discussion | 1 | June 22nd, 2005 06:03 AM |
print multiple records on one sheet (access) | Dave UK | General Discussion | 1 | May 24th, 2005 01:58 PM |
print one label multiple times on one sheet in access | neeti | Database Design | 3 | February 16th, 2005 05:58 PM |
Print all charts in a workbook (multiple worksheets) | aewsaws | Charts and Charting | 3 | December 31st, 2004 10:31 AM |