When you choose to print in Excel, the Print dialog box (Excel 2007) or the File tab of the ribbon (later versions of Excel) allows you to specify many things about the print job. The Print What drop-down list allows you to indicate whether you want to print the selected worksheets, the selection, or the entire workbook. The Print What setting 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 using the Print What controls 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 the Quick Access Toolbar and assign this macro to that button. When you want to print the entire workbook, just click on the button. Easy and quick.