Excel Page Break Preview and Inserting Page Breaks - Excel Essentials

Posted on:  06/13/2023
Excel Page Break Preview and Inserting Page Breaks - Excel Essentials

Excel has three views in the status bar.

  1. Normal
  2. Page Layout
  3. Page Break Preview

We will look at using Page Break Preview to move and lose page breaks and use the Insert Tab to Insert Page Breaks and Reset All Page Breaks. In Page Break Preview, dashed lines are page breaks Excel automatically added. Solid lines are page breaks that were added manually.

Page Break Preview

Page Break Preview

Page Break in Excel

Page Break in Excel

Insert Page Break

  1. Click the row or column where you want to insert a Page Break. 
  2. Click the Page Layout tab.
  3. Click Breaks in the Page Setup group.
  4. Click Insert Page Break.
Insert Page Break

Insert Page Break

YouTube Video

Remove all manually-inserted page breaks

  1. Click the worksheet you want to remove all page breaks 
  2. Click the Page Layout tab.
  3. Click Breaks in the Page Setup group.
  4. Click Reset All Page Break.
Reset All Page Breaks

Reset All Page Breaks

Recent Articles

Mastering Conditional Formatting in Excel with Copilot: A Step-by-Step Guide

Mastering Conditional Formatting in Excel with Copilot: A Step-by-Step Guide

Copilot for Excel - Is it Accurate? 11 Tests Performed

Copilot for Excel - Is it Accurate? 11 Tests Performed

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

March 14, 2024 - Beginner’s Guide to Microsoft Copilot

April 13, 2024 - Excel Training for MBA Students from the University of Georgia

April 13, 2024 - Excel Training for MBA Students from the University of Georgia

OneNote - SORT PAGES  - New Feature - 2022

OneNote - SORT PAGES - New Feature - 2022

3 AWESOME TIPS when working with OneNote & Outlook

3 AWESOME TIPS when working with OneNote & Outlook

Chris Menard

Chris Menard is a certified Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. He runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers. Menard also does 2 to 3 public speaking events every year, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the Support Staff Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at chrismenardtraining.com/linked or watch his videos on YouTube at chrismenardtraining.com/youtube.

Categories