0

excel sheet

The line between D and E is dotted. Why? How can I change it to normal (eg. the line between E and F)?

I am using Excel 2019.

Improve this question

1 Answer 1

Reset to default
4

Those dotted lines indicates the page break, meaning where a page ends and where another start.

To remove it, go to File -> Options -> Advanced -> Display options for this worksheet, untick Show page breaks.

Page break option

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .