How to Clear Print Area in Excel (2 Easy Ways)

A print area is a set of cells that will be printed out in full. Set a print area to only contain your selection if you don’t want to print the complete spreadsheet. On a sheet with a designated print area, only that area will be printed when you press Ctrl + P or click the Print button. In a single worksheet, you can choose numerous print areas, and each one will print on a separate page. The print area is also saved when the workbook is saved. Later, if you change your mind, you can alter it or clear the print area. In this article, we will show you how to clear print area in Excel.


Download Practice Workbook

You may download the following Excel workbook for better understanding and practice it by yourself.


2 Handy Approaches to Clear Print Area in Excel

In some circumstances, we might designate a worksheet’s print area for printing. However, if a worksheet has numerous sheets, each of which has a distinct print area, we need to simultaneously clear all the print areas across all the sheets. We will demonstrate to you how to clear the print area in Excel by utilizing the Page Layout tab and applying VBA Code in the following two methods. Let’s suppose we have a sample data set.


1. Utilizing Page Layout Tab to Clear Print Area in Excel

This first technique explains how to use Excel’s Page Layout tab to clear the print area.

Step 1:

  • At the start of the section, select the range of the data set that you want to print.
  • Here, we will select the range of cells from B2 to E17.
  • Now, go to the Page Layout tab first.
  • Then, choose the Print Area command.
  • Finally, click on the Clear Print Area option.

Sample Data

Step 2:

  • Now, navigate to the File tab.

Sample Data

Step 3:

  • Firstly, select the Print tool.
  • Secondly, click on the Print Selection which is marked by the number 2 with a red circle.
  • Thirdly, choose the ‘Only print the current selection’ option.

Sample Data

Step 4:

  • Here, this is the print area that needs to be printed, and the required region runs from cell B2 to cell E17.

Handy Approaches to Clear Print Area in Excel

Read More: How to Set Print Area in Excel (5 Methods)


2. Applying VBA Code to Clear Print Area in Excel

In this final lesson, we’ll use the Developer tab to develop a VBA code that will clear the print area in Excel.

Step 1:

  • At first, we will open the Developer tab.
  • Then, we will select the Visual Basic command.

Handy Approaches to Clear Print Area in Excel

Step 2:

  • Here, the Visual Basic window will open.
  • After that, from the Insert option, we will choose the new Module to write a VBA code.

Handy Approaches to Clear Print Area in Excel

Step 3:

  • Now, paste the following VBA code into the Module
  • To run the program, click the “Run” button or press F5.
Sub Clear_Print_Area()
    'Declaring Variables
    Dim Mysheet As String    
    'Retrieving activesheet name
    Mysheet = ActiveSheet.Name   
    'Selecting print area
    ActiveSheet.PageSetup.PrintArea = "B2:E15" 
    'Displaying the printpreview
    ActiveSheet.PrintPreview
End Sub

Handy Approaches to Clear Print Area in Excel

VBA Code Breakdown

  • Firstly, we will call our subject Clear_Print_Area().
  • Secondly, we declare the variable as  Dim Mysheet As String.
  • Thirdly, we retrieve the active sheet as Mysheet = ActiveSheet.Name.
  • Then we select the print area in the activesheet as ActiveSheet.PageSetup.PrintArea = “B2:E15”.
  • Finally, after running the program, the print preview will be displayed as    ActiveSheet.PrintPreview.

Step 4:

  •  Finally, this is the print area that we need to print by setting the specified area from B2 cell to E15 cell.

Handy Approaches to Clear Print Area in Excel

Read More: How to Set Print Area to One Page in Excel (with Easy Steps)


Conclusion

In this article, I’ve covered 2 handy methods to clear the print area in Excel. I sincerely hope you enjoyed and learned a lot from this article. Additionally, if you want to read more articles on Excel, you may visit our website, Exceldemy. If you have any questions, comments, or recommendations, kindly leave them in the comment section below.


Related Articles

Bishawajit Chakraborty
We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo