Excel Print Settings

After you enter data into your Excel spreadsheet, it’s time to print it out. You click the Print command. It displays a dialog box with a section labeled Print What. You think the answer is obvious! Print the information I just entered, right? Not so fast. People have printing needs that varies from printing a selection of a worksheet to the entire worksheet, from the current worksheet in use to all worksheets in a file. You will see the Excel Print dialog box present you with 4 choices of printing in the Print What section: Selection, Active Worksheet, Entire Workbook and List

Selection

Print a selected block of cells, rows or columns in a worksheet.

Active Worksheet

This is the default print setting that prints the current worksheet in use.

Entire Workbook

Print all worksheets, with data, in a workbook.

List

Print a list that is filtered or unfiltered. If there is no list in an Excel workbook, the list option is ‘grayed-out’, meaning there is no list available to display this option.

Keep this article and more Microsoft Excel tips at your fingertips. Bookmark Your MS Excel Trainer or make Your MS Excel Trainer a Favorite.

Post Footer automatically generated by Add Post Footer Plugin for wordpress.