Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Set Print Area in Excel

How to Set Print Area in Excel

Asmi DhakalBy Asmi DhakalJanuary 5, 2023
how to set print area in excel

You can set a particular cell or a cell range as a Print Area if you wish to print only that selection instead of the entire document. For example, if you’re calculating the sum of total sales, you would only want to print the results. When you set the result cell range as Print Area, you do not have to create an entirely new document to place and print the results.

Once you create a Print Area, you can later add more sections to the existing Print Area. Allocating a section as a Print Area is especially useful if you frequently print values from a particular area in your worksheet.

Table of Contents

  • Step 1: Set a New Print Area
  • Step 2: Add to an Existing Print Area
  • Step 3: Edit Range in Print Area
  • Step 4: Clear Print Area

Step 1: Set a New Print Area

You can add a new Print Area in your worksheet from the page layout tab in the menubar.

  1. Launch Excel.
  2. Select the range you want to print values from the grid.
  3. Head to Page Layout.
  4. Click Print Area > Set Print Area.
    Set Print Area Excel

Step 2: Add to an Existing Print Area

You can add a new area to the existing Print Area. However, if the area is not neighboring your existing Print area, Excel prints the added Print Area to a different page.

  1. On your workbook, select the cell range.
  2. Select Page Layout from the menubar.
  3. Click Print Area > Add to Print Area.
    Add to Print Area Excel

Step 3: Edit Range in Print Area

If you’ve added a range you did not intend to set as Print Range, you can remove the individual range from the Page Setup Window. Similarly, you can also enter cell ranges to add to the Print Area.

  1. Open your worksheet.
  2. Head to Page Layout.
  3. In the Page Setup section, click the expand icon.
    Expand Page Setup
  4. Select the Sheet tab.
  5. Add or delete your range in the Print area.
    Edit Print Area Page Setup

Step 4: Clear Print Area

Excel displays an alert when you set a single cell as a Print Area to confirm your action. You can select the Cancel button from the warning message to clear the Print Area.

You can clear all Print Areas from the Page Layout tab.

  1. Head to Page Layout from your worksheet.
  2. Select Print Area.
  3. Choose Clear Print Area.
    Clear Print Area
how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
how to find links in excel

How to Find and Edit External Links in Excel

January 13, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
how long does a cmos battery last

How Long Does a CMOS Battery Last

January 25, 2023
thunderbolt vs usb c

Thunderbolt Vs USB C: What’s the Difference

January 25, 2023
how to find hidden folder in laptop

How to Find Hidden Folder in Laptop

January 24, 2023
You may also like
how-to-connect-headphones-to-tv

5 Ways to Connect Headphones to TV

January 29, 2023
connect-airpods-to-samsung-tv

How to Connect AirPods to Samsung TV? (Step-by-Step Guide)

January 29, 2023
AIO Pump Not Working

AIO Pump Not Working? Here’s How to Fix It

January 29, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.