Print a worksheet or workbook

Before you print

Before printing anything in Excel, keep in mind that there are a variety of options available for the highest print experience. For further information, see Printing in Excel.

Important: Some formatting, such as coloured text or cell shading, may appear stylish on the screen but look completely differently when it printed on a black-and-white printer. You may also decide to print a worksheet with visible gridlines to ensure that the data, rows, and columns have a much clearer appearance.

Print one or several worksheets

  1. Firstly, select the worksheets that you want to print. 
  2. Secondly, select File > Print, or press CTRL+P.
  3. Thirdly, press the Print button or modify Settings before you select the Print button.

Print one or several workbooks

All workbook files that you want to print must be in the same folder.

  1. First, click File > Open.
  2. Next, hold down CTRL click the name of each workbook to print, and then click Print.

Print all or part of a worksheet

  1. Firstly, click the worksheet, and then select the range of data that you want to print.
  2. Secondly, click File, and then click Print.
  3. Thirdly, under Settings, click the arrow next to Print Active Sheets and select the appropriate option.
  4. Fourthly, click Print.

Need more help?

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice.

Leave a Reply

%d bloggers like this: