Cloud Training (Online)




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.
image

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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.