#1
|
|||
|
|||
Print Area - setting Print Area on large sheets
Is there a method of setting the "Print Area" quickly on a large sheet. The method I use seems out of date. I start with the bottom right cell that I want printed and then move the cursor up to the little white triangle in the top left corner near cell A1. This works but takes time waiting for the sheet to scroll through all the lines I want printed.
|
#2
|
|||
|
|||
You could always setup the print area as a quick "named range", you could setup multiple different named ranges and then when you want to set it as the Print Area simply click the Name Box drop down menu, select the range you want to set as the Print Area, Excel would highlight the area instantly and then go to Print Area > Set Print Area. Use the Name Manager to setup a named range or the Name Box if you are familiar with this method.
This method would allow you to switch between multiple different named ranges and set them as the print area where and when needed. Let me know if you need more information. |
#3
|
|||
|
|||
Is it part of code?
Code:
ActiveSheet.PageSetup.PrintArea = "=" & ActiveSheet.UsedRange.Address |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Page print area | namyeyelus | Excel | 1 | 07-15-2014 10:05 AM |
Page number is set outside print area | sgp22 | Word | 2 | 06-18-2014 11:06 AM |
How to edit cell data without changing print area. FIXED print area | VictoriaT8 | Excel | 3 | 02-22-2013 07:54 PM |
Markup Area Too Large | sthguard | Word | 2 | 06-17-2011 02:14 AM |
Section 1 margins outside print area | Doc_man | Word | 2 | 04-29-2011 03:46 PM |