Printing a Worksheet

Printing a paper copy is a common way to review and share a document. You can print a copy of your worksheet by clicking the Print button on the Standard toolbar or on the Print Preview toolbar. When you use the Print button, Excel prints the selected worksheet with the current Print dialog box settings. You can open the Print dialog box to specify several print options, such as choosing a new printer, selecting the number of pages in the worksheet you want printed, and specifying the number of copies.

Print a Worksheet Quickly

Click the Print button on the Standard toolbar.

Excel prints the selected worksheet with the current Print dialog box settings.

Specify Print Options

Click the File menu, and then click Print.

If necessary, click the Name list arrow, and then click the printer you want to use.

Select whether you want to print the entire worksheet or only the pages you specify.

Select whether you want to print the selected range, the active worksheet(s), or all the worksheets in the workbook with data.

Select the number of copies you want.

Click OK.