formula for entire row pops up when editing a formula and I hit space while holding shift key

Is there a way to turn this "feature" off?

Dave
LVL 42
dlmilleAsked:
Who is Participating?
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Connect With a Mentor Microsoft MVP ExcelCommented:
The simplest way might be to remember not to hold down the shift key when pressing space. :-))
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

Shift-space and Ctrl-space are the keyboard shortcuts for selecting an entire row or column respectively.

When typing a formula, they do the same, i.e. give you the reference for that entire row or entire column.

cheers, teylyn
0
 
dlmilleAuthor Commented:
lol - its a pain - especially when typing fast, to see that come up.

Apparently, others have this pain and it would take macro work to turn that "feature" off.  Never intentially have used these two shortcut keys, lol.

Thanks,

Dave
0
All Courses

From novice to tech pro — start learning today.