Hi,

 

In Excel 2010, I found that once “Page Break View” is selected, there will be dashed lines across the view even after returning to “Normal” view. These dashed lines can be distracting.

 

Is there a way to remove them?

 

 

Bob

Yes use

File -> Options -> Advanced

Scroll down to Display options for this worksheet and remove the tick in Show Page breaks.

 

Unfortunately it's sheet specific so you'll have to do it everytime it happens until you've done all the sheets.

Unless you develope some VB to do it for you,

 

G North,

This solution worked. Thanks.

 

Bob

If you need to fix this for multiple worksheets, just select all desired worksheets then follow the File -> Options -> Advanced steps.   When you scroll down to "Display options for this worksheet" the comboBox should read, "Multiple Selected ..."  Any settings changes made here will apply to all selected worksheets.

• Proposed as answer by gnehsse Monday, November 24, 2014 7:08 PM

Thank boro