Welcome toExcel2007.Tips.Net
Helpful Links
ExcelTips
Family Tips
Home Tips
Money Tips
Newest Tips
Using Conditional Formatting to Shade Rows
Making Sure Duplicate Names Aren't Entered
Applying a Conditional Format to a Full Row
Subscribe
Displaying Page Breaks
Summary: Page breaks can be added to a worksheet manually or automatically. If you want to see where Excel places page breaks, you'll want to pay attention to this configuration tip.When you are formatting a worksheet, you may want to see where Excel will insert page breaks in your printout. This is easily done by using the Print Preview option, or by using the Page Break Preview feature. (Both of these features are covered in other issues of ExcelTips.) You may also want to see the page breaks when you are again editing the worksheet.
Excel can display page breaks as dashed lines between rows or columns on your worksheet. To enable this display, simply follow these steps:
- 1 Click the Office button and then click Excel Options. Excel displays the Excel Options dialog box.
- At the left side of the dialog box, click Advanced.
- Scroll through the list of options until you see the Display Options for This Worksheet section. (Click here to see a related figure.)
- Make sure the Show Page Breaks check box is selected.
- Click on OK.
Related Tips:
Save Time! WordTips has been published weekly since early 1997. Past issues are available in convenient WordTips archives. Have your own enhanced archive of WordTips at your fingertips, available to use at any time! Check out WordTips Archives today!