In other issues of ExcelTips you learn how you can set a print area within a worksheet. This special area is used to define exactly what range you want printed. At some point you may need to delete the print area. (By "delete" I mean to get rid of the special area designation, not the information contained within that area.)
To clear the print area, follow these steps:
Pretty easy, huh? Well, there are other ways you can go about clearing the print area, as well. This is one that I like to use from time to time:
Figure 1. The Define Name dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2963) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Clearing the Print Area.
Comprehensive VBA Guide Visual Basic for Applications (VBA) is the language used for writing macros in all Office programs. This complete guide shows both professionals and novices how to master VBA in order to customize the entire Office suite for their needs. Check out Mastering VBA for Office 2010 today!
In a large worksheet, you may want to display and print just a portion of the available data. Displaying the desired ...
Discover MoreExcel allows you to specify an area of your worksheet that should be printed. Here's how to "lock" that area so it cannot ...
Discover MoreNeed to print several portions of a worksheet all on a single piece of paper? Here's an easy way you can get what you ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-11-01 15:01:10
michael thomas
I tried to print my data in portrait format. Then I see that landscape is more suitable. Then I can't clear the (portrait)page area names with neither of your suggestions.
So I marked the page and exported it as a csv file and loaded it back to a new file as xls data. data, columns etc. had to be reformatted.
(I don't know how to export a whole xls file, but exporting a worksheet works)
2015-10-31 21:58:30
John Wirt
Useful tip today. john Wirt
2015-10-31 17:20:21
Mandora
In VBA, the following code will clear a print range before setting a new one.
ActiveSheet.PageSetup.PrintArea = ""
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2021 Sharon Parq Associates, Inc.
Comments