• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Page Breaks in Excel

April 8, 2021 by Andrew Childress
Page breaks Excel

A page break is where a file divides when you print it. Let’s learn how to work with page breaks in Microsoft Excel with these easy steps.

A page break is where a file divides when you print it. They exist in spreadsheets too. Let’s learn how to work with page breaks in Microsoft Excel.

How to View Page Breaks in Excel

Often, you may want to print out your Excel spreadsheets. When you do, it’s helpful to know where the rows and columns will split across multiple sheets of paper. These are called page breaks, and they’re easy to see and manipulate in Excel.

Consider a lengthy spreadsheet. It won’t fit on a single sheet of paper, so somewhere, there will be page breaks. To display them, find the View tab on Excel’s ribbon. Views in Excel default to Normal view, which is the standard workspace. To view page breaks, click on the Page Break Preview button.

Page break Excel

Excel is now in the Page Break Preview mode. Page breaks are indicated by the blue dashed lines visible as you scroll through the spreadsheet.

Page breaks Excel

If you want to change the location of a page break, click and drag on the dashed lines. Move to a new row, and release. You’ll see that the line is now solid blue. This signifies a page break that you’ve added manually.

Add page break Excel

How to Add Page Breaks in Excel

Sometimes, you’ll want to add page breaks manually. To do this, go to the Page Layout tab on the ribbon, while still working in the Page Break Preview mode.

Imagine that you want to break at row 30. Highlight the row immediately below by clicking on row 31’s row number. Then, on the menu bar, click the Breaks dropdown and choose Insert Page Break.

View page breaks in Excel

Excel will instantly insert a new page break at the selected location.

As you can see, it’s easy to work with page breaks in Microsoft Excel. This is a great way to precisely control the look and feel of your printed spreadsheets.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Add watermark to ExcelWatermark in Excel
Next Post:Calculate Variance ExcelCalculate variance in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top