How to Show Page Breaks in Excel 2010

Microsoft Excel 2010 data is typically best viewed on your computer screen. Unfortunately, it just is not always possible to force someone to view it that way. So you need to learn how to adjust the settings in Excel 2010 so that documents are properly formatted for printing. An important element of this is simply knowing where a page ends or begins, which is why it can be helpful to know how to show page breaks in Excel 2010. With page breaks visible on your screen by default, you will always know what data in your spreadsheet is going to fit on a page, and what data is going to be pushed to another page.


Show Excel 2010 Page Break Lines by Default


Like many of the other default changes that you can make to an Excel 2010 spreadsheet, the setting that you need to modify is found on the Excel Options menu. Changes that you make in this menu will affect the default way that your spreadsheet is displayed, and the default way that it operates. What this means is that a change to the Excel Options menu will automatically be applied to all new documents until you choose to change that option again.


Step 1: Launch Microsoft Excel 2010.

Step 2: Click the File tab at the top of the window.

excel 2010 file tab


Step 3: Click Options at the bottom of the left column to open the Excel Options window.

open excel 2010 options menu


Step 4: Click Advanced in the column at the left side of the Excel Options window.

advanced tab on excel options menu


Step 5: Scroll to the Display options for this worksheet section, then check the box to the left of Show page breaks. Note that this is only changing the option for the worksheet that is currently active. If you want to make this change for other worksheets, you will need to create that sheet in the current workbook, then choose the sheet from the drop-down menu to the right of Display options for this worksheet.

how to show page breaks in excel 2010


Step 6: Click the OK button at the bottom of the window. You should now see the page breaks on the current worksheet. newsletter
vintage t rex t-shirt

Disclaimer: Most of the pages on the internet include affiliate links, including some on this site.