View How To Remove Dotted Lines In Excel Workbook Background. When you've formatted your spreadsheet for print. But you cannot just wake up and remove dotted lines from a spreadsheet, you first have to learn how to remove print lines.

In microsoft excel we can find the delete cells on the home menu which is shown in the below screenshot.

Gridlines in excel are the horizontal and vertical gray lines that differentiate between cells in a worksheet. Here's how to deal with dotted lines in excel. Removing blank spaces and rows in excel is easy and can be done by using find & select for all of the blank spaces. It will look empty, but you will see a tiny dot.