Welcome toExcel.Tips.Net
Helpful Links
Tips.Net Home
ExcelTips Home
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Learn Access Now
Free Printable Forms
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Legal Tips
Money Tips
Organizing Tips
Pest Tips
Pet Tips
Wedding Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site
Newest Tips
Filtering Columns for Unique Values
Printing Multiple Worksheets on a Single Page
Subscribe
RSS Feeds
Daily Nuggets (an ExcelTip every day)
Allen Wyatt's ExcelTips (the weekly classic)
Controlling Display of Page Breaks
Summary: Page breaks in a worksheet are helpful, as they allow you to format your data for printout. It can be helpful to see, on-screen, where those page breaks are placed. This tip explains how to make the breaks visible. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)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:
- Choose Options from the Tools menu. Excel displays the Options dialog box.
- Make sure the View tab is selected. (Click here to see a related figure.)
- Make sure the Page Breaks check box is selected.
- Click on OK.
If you are using Excel 2007 then the steps to follow are a bit different:
- 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.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3008) applies to Microsoft Excel versions: 97 2000 2002 2003 2007
Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.Check out ExcelTips: Filters and Filtering today!