Velvet Star Monitor

Standout celebrity highlights with iconic style.

updates

Why there is dotted line in Excel?

Writer Olivia Zamora

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.

1 Answer

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

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy