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: Printing without Opening.
by Allen Wyatt
(last updated January 9, 2016)
If you need to quickly print the contents of a workbook without actually opening the workbook, you can do so by using one of the helpful features of Windows. Simply follow these steps:
The only thing printed in the workbook is the single worksheet that was selected when the workbook was last closed. It is also printed to whatever you are using as the current printer. If you want to print using different specifications (i.e., a different printer or area of the workbook) then you must first open the workbook in order to print.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2515) 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: Printing without Opening.
Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!
Need the same print range set for different worksheets in the same workbook? It can't be done in one step manually, but ...Discover More
The Print Preview feature can be a great way to see how something will look on paper without actually using any paper. ...Discover More
Need to print more than a single copy of a worksheet? You can do it easily by using the controls in the Print dialog box.Discover More
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.