How to hide page breaks in worksheets in Microsoft Excel ?

When the page breaks is used to adjust the print area in a worksheet in excel , this would show up as dotted lines in the worksheet. You can un-hide the page breaks from the worksheets by un-selecting the “Show Page Breaks” option from Microsoft Excel Options Dialog Window.

How to hide page breaks in worksheets in Microsoft Excel ?

Follow the below steps to hide page breaks in worksheets in Microsoft Excel.

1. Navigate to File (Office Button) -> Options in Excel.

2. In the Excel Options dialog , select “Advanced” from the left sidebar and uncheck the “Show page breaks” checkbox under the “Display options for this worksheet” section.

3. Click OK button and now you should notice that all the page breaks would be hidden from the worksheet.

If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Reply


Interesting BlogPosts to read

How to print title on every page in Microsoft Excel?
Most of the time we might end up having a long workbook with huge amount of data and they have lot o...
How to quickly remove multiple line breaks in Excel using VBA code?
There are times when you might copy few data from different source and you would end up getting unne...
How to change orientation of the worksheets in Microsoft Excel ?
This blog post will show the steps that are needed to change the orientation of the current workshee...