Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

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
0
dlmille
Asked:
dlmille
  • 2
1 Solution
 
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
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The simplest way might be to remember not to hold down the shift key when pressing space. :-))
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now