How to Set Print Area in Excel - Compute Expert

How to Set Print Area in Excel


Home >> Excel Tutorials from Compute Expert >> Excel Tips and Trick >> How to Set Print Area in Excel



In this tutorial, you will learn how to set the print area in excel completely.

When you want to print your Excel document, you may sometimes want to print only certain areas of your worksheets. By setting the print area in excel before you print, you can print only the areas you want easily.

Want to know the way to set print area in excel so you can print your excel document according to preference? Read this tutorial until its last part!







How to Set Print Area in Excel: a Step-by-Step Guide

If you have already mastered it, the way to set print area in excel is actually pretty simple. Here are the complete steps to do it.

  1. Highlight the cell range you want to set as the print area in your worksheet

    How to Set Print Area in Excel - Screenshot of Step 1

  2. Go to the Page Layout tab, click the Print Area dropdown button, and choose Set Print Area

    How to Set Print Area in Excel - Screenshot of Step 2

  3. Done! Excel has set the cell range you highlight as its print area. You can see the print area mark in the form of gray border lines around the cell range

    How to Set Print Area in Excel - Screenshot of Step 3




How to Set Multiple Print Areas in Excel

Need to set multiple, non-adjacent print areas in your excel worksheet?

Just press and hold the Ctrl (Command in Mac) button while selecting non-adjacent cell ranges before you set your print area. By doing that, you should be able to highlight non-adjacent cell ranges at the same time like this.

How to Set Print Area in Excel - Screenshot of the Multiple Cell Range Highlight Result Example

Then, just set your print area by using the steps we have discussed before (starting from step 2). By doing that, you have set multiple print areas in your excel worksheet!

How to Set Print Area in Excel - Screenshot of the Multiple Cell Range Print Area Settings Result




How to Modify Print Area in Excel

Once you have set the print area in your worksheet, you may want to modify it occasionally. To do that is also quite simple.

You can just redo the steps to set your print area if you want to set it up all over again. Or, if you want to just edit your current print area, then you can do these steps below.

Go to the Page Layout tab in your excel file and click the Page Setup button there.

How to Set Print Area in Excel - Screenshot of the Page Layout Tab and Page Setup Button Locations

In the dialog box that shows up, go to the Sheet tab. In there, you should see the Print area text box where you can edit the print area you have set.

How to Set Print Area in Excel - Screenshot of the Sheet Tab and Print Area Text Box Locations in the Page Setup Dialog Box

You can edit your current print area by correcting the cell range coordinate typing in the print area text box. You can also drag across your worksheet in the text box to input a new cell range.

If you need to add non-adjacent cell ranges for your print area, just type a comma sign. Then, enter the new cell range you want to add.

After you finish modifying your print area, click the OK button in the dialog box to finish the modification process.



How to Clear Print Area in Excel

To clear the print area you have set in your excel file, just go to the Page Layout tab. Then, click the Print Area dropdown button and choose Clear Print Area.

How to Set Print Area in Excel - Screenshot of the Page Layout Tab, Print Area Dropdown Button, and Clear Print Area Choice Locations

By doing that, you have removed the print area you have set!



Setting Print Areas Not Working? Possible Solution

You cannot set the print area you want in excel?

Try to clear your current print area before trying to set up a new one. By doing that, you should be able to set up the print area without a problem!



Additional Note

If excel cut the columns in your print area into separate pages and you don’t want that, do this. In your print settings, set the scaling setting into Fit All Columns on One Page.

How to Set Print Area in Excel - Screenshot of the Print Scaling Settings and Fit All Columns on One Page Choice Locations

By doing that, you should have all the columns in your print area intact!



Related tutorials you should learn from:



Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!


Want to Learn More About Excel?


Get updated excel info from Compute Expert by registering your email. It's free!



Follow our tutorial content also on




Hand-Picked CE Tutorials

Excel Calculation

How to Sum in Excel

Subtraction in Excel

Multiplication in Excel

Division Excel Calculation

Average Excel Calculation



Excel Formula

VLOOKUP Excel Formula

Excel IF Function

SUM Formula in Excel

COUNTIF Formula in Excel

COUNT Function in Excel



Excel Tips and Trick

How to Print in Excel

Convert Number to Text Excel

Excel Worksheet Definition

Excel Range Definition

How to Add Columns in Excel



Excel Consultation

Contact Us

Privacy Policy

Affiliate Disclosure

Terms & Condition



© 2021 Compute Expert