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?
Hi Jan, it does not happen in safe mode...
@Jan Karel Pieterse
@danandrew , not sure about first question, Ctrl+Shift+Arrow shall work on all versions of Excel. I'd try to repair.
I@Jan Karel Pieterse I tried that... no change. Do I need to just action the active ones or the inactive ones too?