Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 189
  • 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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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