A Persistent ViewĪlthough you turn on the Page Break Preview feature on the “View” tab, the preview screen will remain displayed even if you go to different tabs, such as “Insert” and “Page Layout”. The spreadsheet will then go back to using to the page breaks that Excel added.
Select the “Reset All Page Breaks” option. Right-click any cell in the spreadsheet. #Remove page breaks in excel 2016 for mac manual#
You can use the reset functionality to delete all the manual page breaks at once. Occasionally, you might find that a spreadsheet has so many page breaks that the easiest way to get it to flow properly is to start from scratch.
You cannot delete page breaks that Excel has automatically added. The easiest method is to drag the page break line outside the preview area. If you discover that a page break you added is hurting rather than helping the spreadsheet’s layout, you can delete it. (If you want to insert a vertical page break, select the column to the right of where you want to insert the break.) This row will be at the top of the new page.
Highlight the row where you want to insert the page break. Sometimes you might want to insert a page break into your spreadsheet. If the box is not checked, click it to enable Excel’s drag-and-drop functionality. Find the “Enable fill handle and cell drag-and-drop” check box in the “Editing options” section. Choose “Options” at the bottom of the left pane. (In Excel 2007, click the Microsoft Office button.) However, if you find that you cannot drag a page break line to a new location, you should do the following: This functionality is enabled by default. To move page breaks in this manner, Excel’s drag-and-drop functionality needs to be working. This subtle difference is important if you decide to reset a spreadsheet’s page breaks, which will be discussed later. When you move a page break that Excel had inserted (i.e., an automatic page break), it becomes a manual one. You might notice that, when you move a dashed line, it becomes a solid one in its new location. To move a page break, you simply drag its line to the desired location. If you do not like how the spreadsheet is breaking across the pages, you can move, add, or delete page breaks. Solid lines signify the page breaks manually added by users. Dashed lines indicate page breaks that Excel automatically added. In the Page Break Preview screen, you can see how the rows and columns will break across the pages. Click the “Page Break Preview” button on the left side of the ribbon. Open the spreadsheet you want to print. The Page Break Preview feature is available in Excel 2007 and later versions. Plus, you can adjust any page breaks that are causing problems while in the preview screen. The preview screen gives you a much more detailed view than the one you would see using print preview. You can be left with large gaps on your pages, especially if the height of your rows varies.įortunately, Excel has the Page Break Preview feature, which lets you view how the pages in a spreadsheet will break before you print it. 
While it is easy to manually insert a page break, it can often affect how the remaining pages flow. Printing a multiple-page Microsoft Excel spreadsheet can be frustrating when the pages do not break where you want them to.
0 kommentar(er)
