bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

Tips.Net > ExcelTips Home > Printing > Printing without Opening

Printing without Opening

Summary: Need to print out a worksheet? Chances are good that you can do it without even starting up Excel. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

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 of Windows. Simply follow these steps:

  1. Use the Explorer, My Computer, or any Open dialog box to display the worksheet that you want to print.
  2. Right-click on the file. Windows displays a Context menu.
  3. Choose the Print option from the Context menu.
  4. Windows loads Excel (if it is not already open), opens the workbook, and prints it. The workbook is then closed.

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.

Tip #2515 applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007


More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.
 
Check out ExcelTips: The Macros today!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips

Advertise on the
ExcelTips Site

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)