When it comes to working on Microsoft Excel, there are certain features that may be helpful to understand. One of these features is the page break, and in this article, we will discuss how to manage and view it in Excel 2013.
What is a Page Break in Excel?
Firstly, let’s understand what a page break is. In Excel, a page break is a divider that separates the rows and columns that print on one page from the next. It helps to determine how your worksheets will print and how to fit them into a page.
Page breaks are automatically added based on paper size, margins, and scale options. However, if you want to take more control over where page breaks occur, you can add or adjust them manually. You can also remove page breaks that are already in place.
How to View Page Breaks in Excel 2013
If you want to see where the page breaks are located on your worksheet, you can use the Page Break Preview feature. Here’s how:
- Open the worksheet that you want to view.
- Click on the “View” tab in the ribbon.
- Click on “Page Break Preview” in the “Workbook Views” group.
You will now be able to see the worksheet as it would look when printed. The page breaks will be shown in blue dashed lines.
If you want to exit the Page Break Preview feature and return to normal view, simply click on the “Normal” button in the “Workbook Views” group.
How to Add a Page Break in Excel 2013
If you want to add a page break to your worksheet in a certain location, follow these steps:
- Open the worksheet that you want to add a page break to.
- Select the row or column where you want to insert the page break.
- Click on the “Page Layout” tab in the ribbon.
- Click on the “Breaks” dropdown in the “Page Setup” group.
- Select “Insert Page Break”.
The new page break will be inserted, and the existing page breaks will automatically adjust.
How to Delete a Page Break in Excel 2013
If you want to remove an existing page break in your worksheet, follow these steps:
- Open the worksheet that you want to modify.
- Click on the “Page Layout” tab in the ribbon.
- Click on the “Breaks” dropdown in the “Page Setup” group.
- Select “Remove Page Break”.
The page break will be removed, and the worksheet data will automatically adjust to fill the space created by the removed page break.
FAQs
Q: Can I change the way page breaks are automatically inserted?
A: Yes, you can change the automatic page break settings by going to “Page Layout” > “Page Setup” > “Page” tab > “Scale to Fit” group, and adjusting the “Fit to” settings. You can set the number of pages wide and tall that the worksheet should be, and Excel will automatically adjust the page breaks to fit the new settings.
Q: Why are my manual page breaks not showing up in Page Break Preview?
A: This can occur when the “Show page breaks” option is turned off. To turn it on, go to “File” > “Options” > “Advanced” > “Display options for this worksheet” > “Show page breaks”. Make sure the checkbox is ticked, and the page breaks will now appear in Page Break Preview.
Video Tutorial
For a visual guide on managing and viewing page breaks in Excel 2013, check out this helpful video tutorial:
Conclusion
Page breaks can be a useful feature when working with Microsoft Excel, and being able to manage and view them effectively can improve your productivity and the print quality of your worksheets. By following these simple steps, you can add, remove, and adjust page breaks as needed, and have more control over the layout of your Excel documents.
