34+ How To Remove Dotted Lines In Excel Normal View PNG. If you are familiar with the immediate window in the visual basic editor you can probably more quickly macro1() activesheet.displaypagebreaks = false end sub. If the dotted lines still remain in normal view:

I want that space to be blank?

This is how to remove the solid horizontal lines in normal view. How to remove those annoying dotted page break lines on an excel spreadsheet using one line of vba code. Learn how to operate and grow a business with information from accounting and bookkeeping to how to obtain small business financing, get ideas help and support for all office products: However, the dotted lines of automatically.