Excel Printing - The Print dialog box
The four main option areas in the Print dialog box are:
- Printer – Allows you to choose which printer to print from. To change printers, click on the down arrow at the end of the
Name box and chose from the printers listed in the drop down menu.
- Print range
- All – The default setting – refers only to pages in the workbook containing data.
- Pages – List the start and end page numbers for those pages to be printed.
- Print what?
- Active Sheet – The default setting - prints the worksheet page that was on screen when the Print dialog box was opened.
- Selection – Prints a selected a range on the active page.
- Workbook – Prints pages in the workbook containing data.
- Copies
- Number of copies – Set the number of copies to be printed.
- Collate – If printing more than one copy of a multi page workbook, you can choose to print copies in sequential order.
