What is the Print Area in Excel?

In excel printExcel PrintThe print feature in excel is used to print a sheet or any data. While we can print the entire worksheet at once, we also have the option of printing only a portion of it or a specific table.read more area means designated cells that are frequently printed. For example, we want only specific data to be published in the data. Therefore, we can select those particular cells as the print area.

How to Set & Change Print Area in Excel?

Below are examples of the print area in Excel.

Example #1

Example #2

We have data for a restaurant bill, but we want only the bill to be printed rather than the full worksheet. So, have a look at the data below.

  • First, go to the “Page Layout” tab. Then, click on a “Print Area” under the “Page Setup” section in the “Page Layout” tab. Select the cells which need to be printed. Then, in the “Print Area,” click on “Set Print Area.” Now, press “CTRL + P” for the print option. A dialog box appears. We can see that instead of the whole worksheet being printed, only the specific cells chosen are displayed in Excel’s “Print Preview” section. If we want to print different cells, we can clear the print area by clicking on the “Print Area” and selecting a “Clear Print Area.”

We can see that instead of the whole worksheet being printed, only the specific cells chosen are displayed in Excel’s “Print Preview” section.

We want only the bill to be printed but not the price list.

  • Select the range of the cells which need to be printed. Then, in the “Page Layout” tab under the “Page Setup” section, click on the “Print Area,” then click on the “Set Print Area.”

  • To check the data we selected is being printed, press “CTRL + P” and see the print preview to check.

We can see that we are only printing the bill but not the price list.

Example #3

In a company, an employee’s performance is calculated by a certain weight, and they are given a printout for their report on their annual performance. However, HR does not want to include the weight part of the report.

  • Select the data which needs to be printed. Then, in the “Page Layout” tab under the “Page Setup” section, click on the “Print Area,” then click on “Set Print Area.”

  • To check the data we selected is being printed, press excels shortcutPress Excels ShortcutAn Excel shortcut is a technique of performing a manual task in a quicker way.read more key “CTRL + P” and see the print preview to check.

We can see that we are printing the performance card but not the weight part.

Example #4

We take the same data as from example 3 and suppose that HR now wants to include the weight part also in the report card.

We repeat the same process:

  • Select the data which needs to be printed. Then, in the page layout tab under the page setup”The”Toread more section, click on the “Print Area” and then click on “Add to Print Area.”

We can see that we are now printing all the data.

Explanation

We already know that the print area is a designated area selected to be printed. And, any more frequently printed area is called the print area.

In Excel, a print area means designated cells that are frequently printed. For example, we want only specific data to be printed in the data. Therefore, we can select those particular cells as the print area.

Things to Remember

  • A worksheet can have multiple print areas.Each print area will print as a different print page.

This article is a guide to Print Area in Excel. Here, we discuss how to set and change print areas in Excel, practical examples, and downloadable Excel templates. You may learn more about Excel from the following articles: –

  • How to Print Labels from Excel?How To Print Labels From Excel?In Excel, the Print label option is printed using the word mail merge function. It saves a lot of time to the users in the arrangement of data as it is presented under the single or multiple labels.read moreVBA PrintVBA PrintPrint in VBA is similar to print in Excel. Before using the print command, one must first configure it in VBA. The command prints or writes the data into another file.read moreExcel Print CommentsExcel Print CommentsTo print comments in excel, go to the print section from the files tab and page set up tab, there you will find options to print comments and where you want to display them, whether on the end of the sheet or as they are present in the sheet.read moreHiding a Column in ExcelHiding A Column In ExcelThe methods to hide columns in excel are - hide columns using right-click option, hide columns using shortcut cut key, hide columns using column width, hide columns using VBA code.read more