If you need to quickly print the contents of a workbook without individually opening the workbook yourself (manually), you can do so by using one of the helpful features of Windows. Simply follow these steps:
- Use the Explorer, My Computer, or any Open dialog box to display the worksheet that you want to print.
- Right-click on the file. Windows displays a Context menu.
- Choose the Print option from the Context menu.
- 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.