by Allen Wyatt
(last updated April 24, 2021)
Rod wonders if there is a way to make page breaks darker so that he can see them. He can't tell if he is entering data that will be on a different page when printed. It is very time consuming and annoying to bring up Print Preview after he types something into each cell.
When you display Print Preview (Ctrl+P) and then immediately press Esc, Excel displays page breaks on the screen. These show as dashed lines where the page break appears. They can be difficult to see, as they are easily lost amongst the gridlines normally displayed on the screen.
I say "normally" because you don't have to display gridlines. You can, if you prefer, turn them off. This allows you to more easily see where page breaks appear. To turn off gridlines, follow these steps:
Figure 1. The Advanced options of the Excel Options dialog box.
Now the gridlines are turned off, and your page breaks should be more visible. (They are still dashed lines, but those lines are more visible because of the lack of gridlines.) (See Figure 2.)
Figure 2. With gridlines turned off, page breaks are more visible.
Another way to make page breaks more visible is to remember that Excel provides different ways you can view your worksheet. Two very helpful views are Page Layout and Page Break Preview. You can choose either of the views by displaying the View tab of the ribbon, and either of them make your page breaks very visible.
Page Layout view is, perhaps, the view that provides the most visibility to page breaks as it actually attempts to show your worksheet, as it would look when printed. (See Figure 3.)
Figure 3. Looking at a worksheet in Page Layout view.
The Page Break Preview view doesn't show the whitespace from your printout (which you normally see in Page Layout view), but it does show page breaks using bright blue lines. (See Figure 4.)
Figure 4. Looking at a worksheet using Page Break Preview.
Besides choosing your view from the View tab of the ribbon, you can easily switch between views by using the tools that appear near the bottom-right corner of your worksheet window. (See Figure 5.)
Figure 5. You can switch between views using handy tools.
It should be noted, as well, that if you use either of these views (Page Layout or Page Break Preview), Excel allows you to adjust the zoom magnification level to fit your needs.
Excel is nothing if not versatile when it comes to displaying information in a way that may enhance your use of the program.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (13851) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, and Excel in Office 365.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Excel normally saves workbooks using a default file format that is peculiar to your version of the program. You can ...Discover More
Some people like zero values displayed; others do not. Excel allows you to easily turn the display on or off for a single ...Discover More
Excel allows you to make a wide range of customizations to both the Quick Access Toolbar and the ribbon. If you want to ...Discover More
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
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.