How to Print Selected Area in Excel on One Page (3 Methods)

Method 1 – Using File Tab to Print Selected Area in Excel on One Page

Steps:

Select the area that you need to print. We have selected B4:F12.
Press CTRL+P.

Or, click the File tab.

Click Print.
Click on the first option in Settings.
Select Print Selection.
Click on the Print button. It will print only the current selection of the page.

Method 2 – Printing Selected Area in Excel on One Page with Page Layout tab

Steps:

Select the area you want to print out. We selected the range of cells D5:F12.

Go to the Page Layout tab > the Print Area drop-down > the Set Print Area option.

Click Print Titles under the Page Layout. A Page Setup window will pop up.

Go to Sheet and click on Print Preview. You will see a preview of the specific area that you want to print.

Select the printer you want to use from the Print option of the File.
Click on the Print button.

Note:

The print area that you set will be saved when you save the Excel workbook. If you want to clear the selected area, click Print Area under Page Layout, and select Clear Print Area.

Read More: How to Set Print Area in Excel

Method 3 – Adding Cells to Already Selected Print Area in Excel

You can add new cells to previously selected print area. In this case, we will add all the cells of the column titled “First Name” to Method 2’s print area.

Steps:

Select the cells that you need to add to the current print area.

Go to the Page Layout tab > the Page Setup group > the Print Area drop-down > the Add to Print Area option. After saving the workbook, the print area will be saved.

To view all the print areas, click View> Page Break Preview from the Workbook Views group.

Note:

If the cells that you need to add are not adjacent to the current print area, another print area will be created. Each print area in a worksheet will be printed separately. Only adjacent cells can be added to a current print area to be printed on one page.

Download Practice Book

Printing Selected Area on One Page.xlsx

<< Go Back to Page Setup | Print in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!