Saturday 21 November 2015

Hide Dotted Lines in Excel Showing Page Breaks

Dotted lines showing page breaks are useful to see how adjusting your spreadsheet impacts the printed copy. However, they are not always aesthetically pleasing. To remove them, do the following:

File -> Options (last item)  -> Advanced (middle item) -> Display Options for this Worksheet (appears below Display) -> Deselect Show Page Breaks.

No comments: