how to remove print area in excel

Remove Print Area in Excel: Step-by-Step Guide

By Thomas Moore
AD

Ever opened an Excel document only to find an unwanted print area, typically indicated by a dashed line around cells that will print? Removing print areas can be as simple as following a few steps, and this guide will walk you through that process.

Before we dive in, let's understand print areas in Excel. By default, Excel prints everything unless you've set a specific range to print, which is what we'll target.

Removing the Default Print Area

Excel initially sets the print area to the used range (the range of cells that contain data or formatting). Here's how to remove it:

AD
How to Change the Print Area in Excel - 7 Methods - ExcelDemy
How to Change the Print Area in Excel - 7 Methods - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy

1. Activation: Select the range you want to print. This can be a single cell or a range of cells.

2. Removal: Go to the "Page Layout" tab, then click on the "Print Area" dropdown, and select "Remove Print Area."

How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy
How to Remove Print Margins in Excel (3 Quick Tricks) - ExcelDemy

Understanding the "Remove Print Area" Option

This option clears the entire print area. After using it, nothing will print unless you set a new print area.

AD
  • Caution: Be careful not to confuse this with deleting or hiding cells. Removing the print area only affects what Excel prints, not the content in your workbook.

Removing a Specific Print Area

What if you have multiple print areas and want to remove just one? Here's how:

1. Selection: Click and drag to select the range you've set as the print area.

AD

2. Removal: Right-click the selected range and choose "Remove Print Area."

Printing Multiple Areas from One Sheet

If you want to print multiple areas from the same sheet, don't remove any print areas. Instead, select the cells you want to print and use the "Print" function. Excel will print the selected range, regardless of any set print areas.

AD
  1. Tip: To print without changing any print areas, press Ctrl+P (Windows) or Cmd+P (Mac). Make sure the correct range is selected before you hit print.

So, if you've ever found yourself stumped by a print area that wouldn't budge, you now have the tools to remove it. Just remember, there's a difference between removing a print area and deleting data. Excel keeps your data; it just stops printing it unless you tell it to.

Next time, when setting your print area, be precise. Excel allows you to set print areas as small as a single cell, so take advantage of that precision.

AD