48+ How To Remove Dotted Lines In Excel Mac Images. Dotted lines that appear in an excel worksheet usually represent page breaks, which are displayed so you can see how adjustments to your document affect the printed copy. For printing and presentation purposes, merging cells or cell removing dotted cell borders doesn't necessarily mean removing borders altogether.

Then click on the sort button on the data tab.

No, mac's find & replace doen't work. Before you delete the blank cells, ensure that only the cells that you want to remove are highlighted. Then click on the sort button on the data tab. Of course, there is a simpler and safer method.