Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: Controlling Display of Page Breaks.
There are two types of page breaks that can appear in an Excel worksheet: manual or automatic. You insert page breaks manually by using the Breaks tool on the Page Layout tab of the ribbon. Automatic page breaks are those that are calculated by Excel based on various settings, such as page size, margins, cell size, and the like.
Excel allows you to control whether page breaks are displayed on-screen (as dashed lines) by following these steps:
Figure 1. The Advanced options of the Excel Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (8847) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. You can find a version of this tip for the older menu interface of Excel here: Controlling Display of Page Breaks.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Normally Excel displays row and column headers in a worksheet. If you prefer, you can turn these navigational aids off ...
Discover MoreWhen you insert rows, columns, or cells in a worksheet, does the resulting Insert Options icon bother you? Here's how to ...
Discover MoreExcel allows you to specify where it stores various files used by the program. One location you can specify is where ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2019-07-23 22:43:28
rob
If this option is not selected, page breaks will also be displayed on the worksheet (for the session) after doing a print preview.
2019-07-21 11:36:04
Willy Vanhaelen
@Allan
I you have no objection to using macros, you can copy this one to your personal workbook and asign it to a button in the QAT:
Sub TogglePageBreaks()
ActiveSheet.DisplayPageBreaks = Not ActiveSheet.DisplayPageBreaks
End Sub
It has the advantage that you can turn it on and off at a flip of a switch and also quickly remove them after printing.
2019-07-21 07:03:24
Peter Atherton
Allan
Select all the sheet Tabs before following the instructions in the article. I've only done this in a almost blank workbook but is should work. See the figure
(see Figure 1 below)
Figure 1. Page Breaks for multiple pages
2019-07-20 13:16:10
Allan
Unfortunately, must do this separately for each Worksheet. Would be nice if could do this for a whole Workbook.
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Office 365. If you are using an earlier version (Excel 2003 or earlier), this tip may not work for you. For a version of this tip written specifically for earlier versions of Excel, click here: 
Comments