How to Move Page Breaks in Excel: A Step-by-Step Guide for Beginners

If you’ve ever found yourself wrestling with page breaks in Excel, you’re not alone. It’s a common issue that can make your spreadsheet printouts look messy. Fortunately, moving page breaks in Excel is easier than you might think. Let’s break it down so you can streamline your documents effortlessly.

How to Move Page Breaks in Excel

In this section, you’ll learn how to move page breaks in Excel, enabling you to control how your spreadsheet is divided when printed. This step-by-step tutorial will make the process straightforward and manageable.

Step 1: Open Your Excel Spreadsheet

Begin by opening the Excel file where you want to adjust the page breaks.

Once your Excel file is open, ensure you’re in the right spreadsheet tab. It can be a good idea to preview your document in "Page Break Preview" mode. This way, you can see where the current page breaks are and how they affect your document.

Step 2: Select "View" Tab

Next, click on the "View" tab at the top of the Excel window.

Under the "View" tab, you will find various options for displaying your document. Look for the "Page Break Preview" button, which will give you a clear view of where the page breaks are situated.

Step 3: Click "Page Break Preview"

Now, select "Page Break Preview" from the ribbon.

When you click on "Page Break Preview," your screen will change to show dashed lines where Excel currently has page breaks. Solid blue lines indicate manual page breaks, while dashed lines are automatic ones.

Step 4: Click and Drag the Page Break Line

To move a page break, click on the dashed or solid blue line representing the page break, and drag it to the desired location.

Make sure to release the mouse button once you’ve positioned the page break where you want it. You’ll see the layout updating in real-time, giving you immediate feedback on your adjustments.

Step 5: Return to Normal View

After adjusting the page breaks, go back to the "View" tab and select "Normal" to return to the standard spreadsheet view.

This step is crucial for resuming your work with the usual Excel layout. You can always switch back to "Page Break Preview" later if further adjustments are needed.

Once you complete these steps, you’ll notice that your spreadsheet’s print layout is now more organized. The adjusted page breaks should ensure that the content is divided more logically, making your printed documents look polished and professional.

Tips for Moving Page Breaks in Excel

  • Use Page Break Preview: Always use "Page Break Preview" to get a clear idea of how your changes will impact the layout.
  • Zoom In/Out: Adjust the zoom level to get a better view of where the page breaks are placed.
  • Undo: If you make a mistake, use the "Undo" button to revert your last change.
  • Manual Breaks: If Excel’s automatic page breaks aren’t working for you, consider adding manual breaks.
  • Save Frequently: Always save your work frequently to avoid losing your changes.

Frequently Asked Questions

How do I remove a page break in Excel?

To remove a page break, switch to "Page Break Preview," click on the page break line, and drag it outside the print area.

Can I set page breaks to adjust automatically?

Excel automatically sets page breaks based on the paper size and margins, but you can manually adjust them as needed.

What if I can’t see the page breaks?

If page breaks are not visible, ensure you are in "Page Break Preview" mode under the "View" tab.

How do I reset all page breaks?

To reset all page breaks, go to the "Page Layout" tab, select "Breaks," and choose "Reset All Page Breaks."

Can I move multiple page breaks at once?

No, page breaks must be moved individually.


  1. Step 1: Open your Excel spreadsheet.
  2. Step 2: Select "View" tab.
  3. Step 3: Click "Page Break Preview."
  4. Step 4: Click and drag the page break line.
  5. Step 5: Return to Normal View.


Moving page breaks in Excel doesn’t have to be a daunting task. By following the steps outlined above, you’ll be able to neatly organize your spreadsheet printouts, making them easier to read and more professional-looking. Remember, using "Page Break Preview" can save you a lot of stress by giving you a visual guide of where your breaks will occur.

For further reading, you might want to explore more about Excel’s printing options or delve into advanced formatting techniques. By mastering these skills, you’ll not only improve your productivity but also ensure your documents always look their best.

Don’t forget to practice these steps on a sample spreadsheet before applying them to your important documents. Happy Excel-ing!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy