Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Adding the Set Print Area Tool.
Written by Allen Wyatt (last updated July 7, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
If you have the need to define different areas of a worksheet to print, you know that you can do so by simply defining different print areas in your worksheet. If you need to change print areas quite often, you may be interested in adding a tool to your toolbar that can do this for you. (Using such a tool is much quicker than continually using the menu commands to set a print area.) Follow these steps:
Figure 1. The Commands tab of the Customize dialog box.
Now, when you need to set a print area, you simply choose the area on the screen and click on the Set Print Area button.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3035) 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: Adding the Set Print Area Tool.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. Check out Mastering VBA for Microsoft Office 365 today!
Need to print more than one portion of your worksheet? If you use named ranges for the different ranges you want to ...
Discover MoreWant to print small, non-contiguous areas of your worksheet all on a single page? You might think that defining a ...
Discover MoreEver printed out a worksheet only to find that you have text only at the left side of each page? You can use more of each ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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 © 2025 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments