WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Blog
  • Free Video Tutorials
  • Courses
  • All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Print Area in Excel

Print Area in Excel

By Madhuri ThakurMadhuri Thakur | Reviewed By Dheeraj VaidyaDheeraj Vaidya, CFA, FRM

What is the Print Area in Excel?

Print area in excel is the area which we want to be printed instead of the whole workbook or the worksheet, we can set up a print area from the page out tab, also we can have multiple print area in one worksheet by simply pressing control key while selecting the print area, when we check the print preview we will find that on the data in the print area will be printed rather than the whole worksheet.

In excel print area means designated cell selected, which are frequently printed. For example, in the data, we want only specific data to be printed; we can select those specific cells as the print area.

How to Set & Change Print Area in Excel?

Below are the examples to Print Area in Excel.

Example #1

  • Go to the page layout tab. In the Page Layout tab, click on a print area under the page setup section.

Print Area Example 1

  • Select the cells which need to be printed. In the print Area, click on Set Print Area.

Print Area Example 1-2

  • Now press CTRL + P for the print option, and a dialog box appears.

Print Area Example 1-3

We can see that instead of the whole worksheet being printed, only the specific cells chosen are being displayed in the print preview section in excel.

  • If we want to print any different cells, we can clear the print area by clicking on the Print area and selecting a clear print area.

Print Area Example 1-4

Example #2

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

Print Area Example 2

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

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course
  • Select the range of the cells which need to be printed. In the page layout tab under the page setup section, click on the print area, then click on the Set Print area.

Print Area Example 2-1

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

Print Area Example 2-2

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

Example #3

In a company, the performance of an employee is calculated by a certain weight, and they are given a print out for their report on their annual performance. HR, however, does not want to include the weight part of the report. Have a look below at the data.

Print Area Example 3

  • Select the data which needs to be printed. In the page layout tab under the page setup section, click on the print area, then click on Set Print Area.

Print Area Example 3-1

  • Now to check the data we selected is being printed, press excels shortcut CTRL + P, and see the print preview to check.

Print Area Example 3-2

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. In the page layout tab under the page setup section, click on the print area and then click on Add to Print area.

Print Area Example 4

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

Print Area Example 4-1

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

Explanation

As we already what Print Area means, which is a specifically designated area that is selected to be printed. And any area which is more frequently to be printed is selected is called Print Area.

In excel, a print area means designated cell selected, which are frequently printed. For example, in the data, we want only specific data to be printed; we can select those specific cells as the print area.

Things to Remember

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

Recommended Articles

This has been a guide to Print Area in Excel. Here we discuss how to set and change Print Area in Excel along with practical examples and downloadable excel template. You may learn more about excel from the following articles –

  • How to Print Labels from Excel?
  • VBA Print
  • Excel Print Comments
  • Hiding a Column in Excel
63 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

Special Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More