Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 12-23-2014, 11:41 AM
nfotx nfotx is offline Mac OS X Office for Mac 2011
Novice
 
Join Date: Dec 2014
Location: CA
Posts: 15
nfotx is on a distinguished road
Cool 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.
Reply With Quote
  #2  
Old 12-25-2014, 05:29 AM
thetraininglady thetraininglady is offline Windows 7 64bit Office 2010 32bit
Competent Performer
 
Join Date: Sep 2014
Location: Sydney, Australia
Posts: 214
thetraininglady is on a distinguished road
Default

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.
Reply With Quote
  #3  
Old 12-27-2014, 10:21 PM
jolivanes jolivanes is offline Windows XP Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 83
jolivanes will become famous soon enough
Default

Is it part of code?

Code:
ActiveSheet.PageSetup.PrintArea = "=" & ActiveSheet.UsedRange.Address
Reply With Quote
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 10:51 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft