Welcome toExcel.Tips.Net
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
When you choose to print in Excel, the Print dialog box has controls that allow you to specify many things about the print job. The controls in the Print What area of the dialog box allow you to indicate whether you want to print the selected worksheets, the selection, or the entire workbook. The option in the Print What area normally defaults to Active Worksheets, but what if you want it to default so the entire workbook is printed?
Unfortunately, Excel does not remember what you select in the Print What area from one print job to the next; it always resets the default. The easiest way to always print the entire workbook, however, it to make a simple little macro like this:
Sub PrintItAll()
ActiveWorkbook.PrintOut
End Sub
You can then create a button on a toolbar and assign this macro to that button. When you want to print the entire workbook, just click on the button. Easy and quick.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2001) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Save Time! ExcelTips has been published weekly since late 1998. Past issues of ExcelTips are available in convenient ExcelTips archives. Have your own enhanced archive of ExcelTips at your fingertips, available to use at any time!