Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2014, 11:41 AM
nfotx nfotx is offline Print Area - setting Print Area on large sheets Mac OS X Print Area - setting Print Area on large sheets Office for Mac 2011
Novice
Print Area - setting Print Area on large sheets
 
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 Print Area - setting Print Area on large sheets Windows 7 64bit Print Area - setting Print Area on large sheets 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 Print Area - setting Print Area on large sheets Windows XP Print Area - setting Print Area on large sheets Office 2007
Advanced Beginner
 
Join Date: Sep 2011
Posts: 93
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
Print Area - setting Print Area on large sheets 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
Print Area - setting Print Area on large sheets How to edit cell data without changing print area. FIXED print area VictoriaT8 Excel 3 02-22-2013 07:54 PM
Print Area - setting Print Area on large sheets Markup Area Too Large sthguard Word 2 06-17-2011 02:14 AM
Print Area - setting Print Area on large sheets Section 1 margins outside print area Doc_man Word 2 04-29-2011 03:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:11 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft