Forum Discussion

danandrew's avatar
danandrew
Copper Contributor
Apr 11, 2019

Odd things happening

Hi folks,

a couple of weeks ago two things started happening in my excel that I cannot find a solution for anywhere.

(1) when I start typing a formula, all groups expand in my excel sheet.  How do I disable this feature?

(2) I can no longer highlight continuous data by holding ctrl+shift+arrow.

 

Any advice on the above?

 

Thanks,

Dan

excel

6 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 11, 2019

    danandrew , not sure about first question, Ctrl+Shift+Arrow shall work on all versions of Excel. I'd try to repair.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 11, 2019
    Does this also happen when you start Excel in safe mode (press and hold the control key when you launch Excel)?
      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Apr 12, 2019
        Start Excel normally and then try turning off your add-ins one by one to see which causes this. Don't forget to also check the COM add-ins. File, Options, Add-ins tab, dropdown close to the bottom of the window, select add-in type and press Go...