Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in
x
or
x
x
Register
x

or

How to clear print area through multiple sheets at once in Excel?

In some cases, we may set a print area in a worksheet for printing, but if there are multiple sheets with different print areas, how can I clear all print areas through multiple sheets at once in Excel? Manually deleting one by one is a slow way, is there any quick way?

Clear print area through the whole workbook with VBA

Clear print area through multiple sheets with Copy Page Setupgood idea3


Clear print area through the whole workbook with VBA


Here is a macro code that can clear all print areas through the entire workbook.

1. Press Alt + F11 keys to enable the Microsoft Visual Basic for Applications window.

2. In the Project – VBAProject pane, double click ThisWorkbook and copy below VBA and paste them into the right blank script. See screenshot:

VBA: Clear print area entire workbook

Sub ClearPrintArea()
'UpdatebyExtendoffice20171229
    Dim xSheet As Worksheet
    For Each xSheet In Worksheets
        xSheet.PageSetup.PrintArea = ""
    Next
End Sub

doc clear print area multiple sheets 1

3. Press F5 key to run the code, then all print areas in the workbook have been removed.


Clear print area through multiple sheets with Copy Page Setup

If you have Kutools for Excel, its Copy Page Setup utility also can do you a favor on clearing multiple print areas through sheets.

Kutools for Excel, with more than 120 handy functions, makes your jobs easier. 

After installing Kutools for Excel, please do as below:(Free Download Kutools for Excel Now!)

1. Select one sheet, for instance, sheet random password, and then click Page Layout > Print Area > Clear Print Area. See screenshot:
doc clear print area multiple sheets 2

2. Then click Enterprise > Printing > Copy Page Setup.
doc clear print area multiple sheets 3

3. Then in the Copy Page Setup dialog,
in the Copy to section, all sheets except the current sheet are listing, please check the sheets you want to clear the print area from;
then go to the Options section, under Sheet list, check the Print area option only. See screenshot:
doc clear print area multiple sheets 4

4. Click Ok. Now the print areas are removed from the selected sheets.



Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, Visio and Project.
  • Open and create multiple documents in new tabs of the same window, rather than in new windows.
  • Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.