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:
- Click on the first tab in the workbook.
- While holding SHIFT, click on the last tab in the workbook.
- On the ribbon, go to the View tab and click “Page Break Preview”
- OR click on the Page Break Preview button at the bottom of the screen (next to the zoom slider)
- For good measure, zoom out to around 50%
- Currently, the tabs are selected in a group. Before doing anything else, go back to single-worksheet mode.
Now all of the worksheets should be in Page Break Preview mode. Now you may check each worksheet’s print area.
Click and drag the blue lines to change the print area.