Excel: Check the print area quickly for all sheets in a workbook


We all hate it when we print a workbook that contains several dozen worksheets only to find out later that one worksheet had a column cut off or split to another page. Many of us have adopted the practice of checking the print area of each worksheet one by one to make sure this doesn’t happen. The problem is that you have to set the view to “Page Break Preview” for each worksheet. I have found a little trick to speed up that process.

To set the view for all worksheets at once:

  1. Click on the first tab in the workbook.
  2. While holding SHIFT, click on the last tab in the workbook.
  3. On the ribbon, go to the View tab and click “Page Break Preview”
    SS-2010.07.28-15.17.08
  4. OR click on the Page Break Preview button at the bottom of the screen (next to the zoom slider)
    SS-2010.07.28-15.18.17
  5. For good measure, zoom out to around 50%
  6. Currently, the tabs are selected in a group. Before doing anything else, go back to single-worksheet mode.
    1. If ALL tabs are selected: click on one of them.
    2. If only some of the tabs are selected: click on an unselected tab.
    3. You’ll be safe when the title bar no longer contains the “[Group]” as shown below:
      SS-2010.07.28-15.23.51b

Now all of the worksheets should be in Page Break Preview mode. Now you may check each worksheet’s print area.

SS-2010.07.28-15.20.07b 

Click and drag the blue lines to change the print area.

Advertisements
  1. #1 by http://easyhomeremodels.yolasite.com/ on February 12, 2013 - 11:21 pm

    I was basically browsing for ideas for my very own weblog and found
    ur posting, “Excel: Check the print area quickly for all sheets in a workbook | CPA Tech Tips”, would you care in the
    event that I make use of some of your own points?

    Thx -Anke

  2. #2 by Batmitzvahhilltopmanor.com on July 17, 2013 - 7:18 am

    Howdy! This blog post could not be written much better!
    Looking through this article reminds me of my previous roommate!
    He always kept talking about this. I most certainly will
    forward this article to him. Fairly certain he’s going to have a great read. I appreciate you for sharing!

  3. #3 by Lize on September 26, 2013 - 10:45 am

    I have one sheet with columns A – AA, and 40 rows. How do I print columns A – L on 1 page and columns M – AA on another without having to change the print area every time – set it static to print like that – I know how to use print area, but my manager not. She just want to fill in the sheet and click on print.

  4. #4 by yodhava on January 7, 2015 - 9:36 am

    thanks, a nice quick notes on what I was looking for.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: