I always thought it was good to see the Page Break dotted lines in an Excel worksheet – they are shown if you have gone to File – Print or to Page Layout view or Page Break Preview. However, one client this week said he found them a nuisance because he often wanted to print on an A3 printer.
To get rid of the dotted lines, for either the worksheet you are working on, click File – Options and go to the Advanced tab. Scroll down until you find the section on Display options for this worksheet. Clicking the dropdown there will allow you to select the whole workbook instead of just the relevant sheet. Get rid of the tick by Show page breaks.
Click OK. There will no longer be any page breaks displayed for that worksheet or for the whole workbook depending on what option you have selected.
Alternatively for a one-off quick fix, go to Page Break Preview, then click the Undo button or click Ctrl + Z. The page breaks again disappear.
Find out more details of our tailored Microsoft Excel training in the London area.
Find out more details about our tailored Microsoft Excel training in Dorset, Wiltshire, Somerset and Hampshire.