Please Note: This article is written for users of the following Microsoft Excel versions: 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 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.
Written by Allen Wyatt (last updated July 20, 2019)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and Excel in Microsoft 365
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 Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Controlling Display of Page Breaks.
Professional Development Guidance! Four world-class developers offer start-to-finish guidance for building powerful, robust, and secure applications with Excel. The authors show how to consistently make the right design decisions and make the most of Excel's powerful features. Check out Professional Excel Development today!
The Ribbon, while debatably handy, can be downright difficult to use for those with a sight impairment. Here are some ...
Discover MoreThe Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to ...
Discover MoreThe Formula bar is used to display the formula that appears in a cell. You may want to modify how the Formula bar is ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-06-24 09:33:44
Philip Andrew
Not showing on my worksheet for some reason.
2020-06-23 14:12:34
David
Still does not appear. No thank you.
2020-06-16 15:58:04
Thanks so much for the help Allen.
Thanks to you and a few others I have been called a spread sheet wizard, although I do not consider myself that good (yet)!
Sincerely,
Alan Scanlan
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 © 2024 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 Microsoft 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