How Are Page Breaks Indicated in Page Break Preview
When you choose Page Break Preview Excel displays the worksheet at a somewhat reduced magnification with the page breaks clearly identified in the worksheet window. How are chart sheets different from worksheets. How To Only Show Print Area In A Worksheet In Excel This figure shows vertical page breaks in the Page Break Preview worksheet view which you can accomplish by following these steps. . Solid lines are breaks that were added manually. If you delete all manual page breaks this resets the spreadsheet to display automatic breaks. NOTE Moving an automatic page break changes it to a manual page break. If you move an automatic page break it becomes a manual break. In page break preview view default page breaks are indicated by a. Click the View drop down menu in main menus. An automatic break that Excel adds is indicated by a dotted blue line whereas a manual break that you add has a solid blue line. To ...