Three different ways for printing a selected area

  • Excel
  • 2016
If you need to print some range of cells in your spreadsheet, you can choose two different options how to do that.
Print preview 1 in Excel 2016 or Print preview 2 in Excel 2016

The easiest way is to select cells you want to print and on the Print tab, in the Settings group, in the Print Area dropdown list, select Print Selection :

Print Selection in Excel 2016

Excel will print selected area of the spreadsheet, for example:

Print preview 1 in Excel 2016

More informative way , where you can add column headers or/and labels to the selected area:

1. On the Page Layout tab, in the Page Setup group, click Print Titles :

Page Setup group in Excel 2016

2. In the Page Setup dialog box, on the Sheet tab, in the Print area field:

Page Setup dialog box in Excel 2016
  • Enter the range of cells you want to print or
  • Click on the arrow and then in the Page Setup - Print area dialog box, select the range of cells you want to print, for example:
    Page Setup - Print area in Excel 2016

    After selecting the print area, just click Enter or click the arrow in the Page Setup - Print area dialog box:

    Print preview 2 in Excel 2016

    See Print column headers or spreadsheet labels on every page for more details.

The third way is to use Print Area .

This way is useful when you have several different ranges of cells you want to print. When you save your workbook, the Print Area of your workbook is saved as well.

1. Select the range of cells you want to print.

2. On the Page Layout tab, in the Page Setup group, click on the Print Area dropdown list:

Print Area in the Page Setup group in Excel 2016

3. In the Print Area dropdown list, click Set Print Area :

Set Print Area in Excel 2016

4. Select the second range of cells:

Set Print Area example in Excel 2016

On the Page Layout tab, in the Page Setup group, in the Print Area dropdown list, select Add Print Area :

Add to Print Area in Excel 2016

For this example:

Add to Print Area example in Excel 2016

Notes :

  • If you click Clear Print Area on the Page Layout tab, in the Page Setup group, in the Print Area dropdown list.

    Excel removes all the print areas on your worksheet.

  • If you want to see all Print Areas in your workbook, select (enter the first letters and then select) Print_Area in Name box :
    Print_Area example in Excel 2016

    Excel highlights all areas had been added to the Print Area.

Transactions Tracking

  • Income
  • Expense
  • Transfer
  • Buy,Sell and Dividend
Track your finances at https://moneybench.net Try Now

Quick Overview

  • Income and Expenses
  • Assets and Liabilities
  • Investments
  • Net worth
Track your finances at https://moneybench.net Try Now

Thank you for visiting OfficeToolTips

We are glad to help you in your work. However, you are using ad blocker and our efforts will not be rewarded.

Please consider disabling ad blocker before continuing the reading.