EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Excel Tips Excel Print Area
 

Excel Print Area

Madhuri Thakur
Article byMadhuri Thakur

Updated August 16, 2023

Print Area in Excel

 

 

Print Area in Excel

Print Area in Excel helps the user print only select areas. We can restrict the area we want to see in our print preview. For example, a worksheet has 4 columns and 20 data-filled rows. But if we want to print only the top 3 rows, go to the Page Layout menu ribbon and select Print Area under the Page Setup section. Now from the Set Print Area, choose the area we want to print. Later we can clear the area.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

How to Set a Print Area in Excel?

It is very simple and easy. Let’s understand the working of the print area with some examples.

You can download this Print Area Excel Template here – Print Area Excel Template

Example #1

We have given some employee data, and we want to print the whole data, excluding the employee’s salary.

Print Area Example 1-1

For setting up the print area in the Excel worksheet, follow the below steps:

  • Select the range of cells you want to print or set as the print area in that worksheet. Refer to the below screenshot.

Print Area Example 1-2

  • Go to the Page Layout tab.
  • Click on the Print Area option under the Page Setup section, as shown in the below screenshot.

Print Area Example 1-3

  • It will open a drop-down list of options.
  • Click on the Set Print Area option, as shown in the below screenshot.

Print Area Example 1-4

  • This option would set the selected range of cells or area as Print Area and also give that area’s name under Name Box. Refer to the below screenshot.

Result

  • You also can change the name of the Print Area as required.

Only the set print area will be printed when you give the print command.

How to Make Changes in the Print Area in Excel?

If you have already set the print area, but after some time, you realize that you need to include more data in the report, then you need to make some changes in the print area setting.

Suppose in the above example, we want to include the Salary field.

To add more areas for printing, follow the below steps:

  • Select the cells you want to add to the already set print area. Refer to the below screenshot.

Print Area Example 1-6

  • Go to Page Layout.
  • Click on Print Area under the Page Setup section. Refer to the below screenshot.
  • Choose the Add to Print Area option, as shown in the below screenshot.

Add

And this would add that selected range of cells in the Print Area.

How to Remove/Clear the Print Area in Excel?

To clear the print area, follow the below steps:

  • Click on any cell in the worksheet in which you want to clear the print area.
  • Go to Page Layout.
  • Click on Print Area under the Page Setup section.
  • It will open a drop-down list of options.
  • Click on Clear Print Area from the list, as shown in the below screenshot.

Remove/clear

These steps will clear all the print areas from the worksheet.

Things to Remember

  • You can define more than one print area in the worksheet by providing different names to that area.
  • Those areas will print separately.
  • When you save the workbook, it saves the Print area as well.
  • While adding more area under the print area, and if those cells or area is adjacent to the existing print area, it would be merged and printed.
  • If that new area is non-adjacent to the existing print area, it will create a new print area and print on a different page.

Recommended Articles

This has been a guide to Print Area in Excel. Here we discuss how to set a Print Area in Excel, practical examples, and a downloadable Excel template. You can also go through our other suggested articles –

  1. Print Comments in Excel
  2. Print Gridlines in Excel
  3. How to Print Labels From Excel
  4. VBA Print

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

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

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA

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

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

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

EDUCBA

Download Print Area Excel Template

EDUCBA Login

Forgot Password?

EDUCBA

Download Print Area Excel Template

EDUCBA

डाउनलोड Print Area Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW