Displaying Page Breaks in Microsoft Excel 2010

Page Breaks in Microsoft Excel 2010 is a really important feature. Page Breaks let you view your data in Microsoft Excel 2010 properly. When you’re taking printout of the data from Microsoft Excel 2010, you need to arrange it properly using Page Breaks so that you would know how the data would be printed on the paper. Page Breaks are typically used to format the data in a right way so that you wouldn’t face any difficulties in printing it later. So let’s see how you can display Page Breaks in Microsoft Excel 2010.

You can make this feature a default feature that would be displayed to you whenever you create a new Microsoft Excel 2010 workbook. If you want to display the Page Break by default, you can tweak the options to do so. You can find the option to change it in the Excel Option menu. Click on ‘File’ and click on ‘Options’ to begin the process. Once you click on ‘Option’, a window would be displayed on the screen which will have various options for you to change and control. Click on the ‘Advanced’ option on that window to change the option for displaying Page Breaks automatically. Once you select the option ‘Show Page Breaks’, save the changes and close the window.

Once you save the changes, Page Breaks would be displayed along with your data when you open any Microsoft Excel 2010 workbook. Ensure that your data is displayed properly within the Page Breaks so that you would not face any difficulty when you have to print the data in your Microsoft Excel 2010 workbooks.