Making Page Breaks More Visible

Written by Allen Wyatt (last updated April 14, 2025)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, and 2021


3

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:

  1. Display the Excel Options dialog box. (In Excel 2007 click the Office button and then click Excel Options. In Excel 2010 or a later version, display the File tab of the ribbon and then click Options.)
  2. Click Advanced at the left side of the dialog box.
  3. Scroll through the options until you see the Display Options for this Worksheet section. (See Figure 1.)
  4. Figure 1. The Advanced options of the Excel Options dialog box.

  5. Clear the Show Gridlines check box.
  6. Click OK.

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 2021.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Word and Character Count Information

Using fields you can easily insert both the word and character counts for a document into the document itself. Here's how ...

Discover More

Quickly Dumping Array Contents

Variable arrays are used quite often in macros. If you use an array once in your macro and then need to reuse it for ...

Discover More

Moving and Selecting Rows

If you need to move down a row and then select that row, you may wonder if there is a shortcut to handle such a ...

Discover More

Dive Deep into Macros! Make Excel do things you thought were impossible, discover techniques you won't find anywhere else, and create powerful automated reports. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable. You’ll find step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and solutions. Check out Microsoft Excel 2019 VBA and Macros today!

More ExcelTips (ribbon)

Animated Recalculation in Excel

Excel includes some animation capability that is enabled by default. If the animation is bothersome to you, then you'll ...

Discover More

Disabling Shift+Ctrl

Both Excel and Windows have scores of defined shortcut keys. This can be great for productivity, but it can be a real ...

Discover More

Fixing the Decimal Point

Don't want to always type the decimal point as you enter information in a worksheet? If you are entering information that ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is 5 - 4?

2021-04-24 09:57:56

J. Woolley

There is an easier way to toggle gridlines on or off; it is not necessary to edit your Excel Options. Using the Ribbon, click View > Show > Gridlines.


2021-04-24 06:09:24

Michael (Micky) Avidan (Excel MVP)

FIGURE 1 SHOULD SHOW:

(see Figure 1 below)

Figure 1. Page Break Preview


2021-04-24 06:07:01

Michael (Micky) Avidan (Excel MVP)

Instead of Dotted page Break Marker (as shown in See Figure 2 above) there is a way to show a SOLID Line.

1) Present the Sheet as "Page Break Preview".

(see Figure 1 below)

2) Move, with the mouse, the Blue Vertical / Horizontal Breakers to the right & down and then return them to their original position.

3) Turn off the "Grid-Line view" of the sheet cells.

The result: Clear SOLID (not dotted) Page Break Markers.

(see Figure 2 below)

Figure 1. Page Break Preview

Figure 2. Clear SOLID (not dotted) Page Break Markers


This Site

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.

Newest Tips
Subscribe

FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.