When you are formatting a worksheet, you may want to see where Excel will insert page breaks in your printout. This is easily done by using the Print Preview option or by using the Page Break Preview feature. (Both of these features are covered in other issues of ExcelTips.) You may also want to see the page breaks when you are again editing the worksheet.
Excel can display page breaks as dashed lines between rows or columns on your worksheet. To enable this display, simply follow 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 (6182) applies to Microsoft Excel 2007, 2010, 2013, and 2016.
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!
Excel allows you to display your workbooks using a couple of different views. If you want to disable one of the views, it ...
Discover MoreExcel, by default, periodically writes information to AutoRecover files that can help protect your data in case Excel is ...
Discover MoreThe Developer tab of the ribbon is the gateway to many advanced features in Excel, including those features related to ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2020-01-10 09:51:01
Radshire
Hi Allen,
Is there a keyboard shortcut to toggle the viewing of page breaks when in Normal View?
My firm has recently installed a piece of software over all our Office documents which forces us to categorise them according to confidentiality. Since this has happened, Excel default settings seem to be overridden and the page break dotted lines appear when categorisation of document is selected.
This is clearly a compatibility bug with the added software.....but hope of resolution on this is slim (to none!)
What I need is a way to toggle the page break dotted lines using a keyboard shortcut so that I can remove them quickly.
I guess the only other alternative is to create my own macro to toggle them, but I'd rather avoid adding to the list of such macros I already have!
Many thanks
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 © 2021 Sharon Parq Associates, Inc.
Comments