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.
- 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.
- Now, navigate to the File tab.
- 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.
- Here, this is the print area that needs to be printed, and the required region runs from cell B2 to cell E17.
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.
- At first, we will open the Developer tab.
- Then, we will select the Visual Basic command.
- Here, the Visual Basic window will open.
- After that, from the Insert option, we will choose the new Module to write a VBA code.
- 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
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.
- Finally, this is the print area that we need to print by setting the specified area from B2 cell to E15 cell.
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.
- [Solved:] Print Area Is Grayed Out in Excel (2 Easy Solutions)
- How to Set Print Area with Blue Line in Excel (5 Easy Ways)
- Print Selected Area in Excel on One Page (3 Methods)
- Excel VBA: Set Print Area for Multiple Ranges (5 Examples)
- Change Print Area in Excel (5 Methods)
- Excel VBA: How to Set Print Area Dynamically (7 Ways)
- How to Center the Print Area in Excel (4 Ways)