7

Consider the following Excel spreadsheet:

Screenshot I

B2 should now say "Hello Brutus!", so I try to type 

="Hello " & B1 & "!"

And, of course, as always, I do not feel the necessity to release the Shift key while I type " & B and & "!". So, Excel does this:

Screenshot II

Screenshot III

How can I deactivate this Shift+Space hotkey (that is of no use for me anyway, I cannot imagine how this can be of any use for anyone)?

Bowi
  • 1,637
  • 2
  • 20
  • 41

3 Answers3

4

Unfortunately Excel doesn't support customized keyboard shortcuts:

One workaround is to use AutoHotkey with the below script

; If you want to disable Shift+Space for all applications
; just comment out the next line
#IfWinActive ahk_exe EXCEL.EXE
+Space::Return
phuclv
  • 30,396
  • 15
  • 136
  • 260
2

You can't. But the good news is that you don't need the spaces that are causing you trouble

Type as

="Hello "&B1&"!"
phuclv
  • 30,396
  • 15
  • 136
  • 260
Ack
  • 633
  • 4
  • 12
0

There is no option for it anywhere. To overcome it in a literal way, you'd need a one line macro that maps the key to being a space. It would look something like:

Application.OnKey "+{SPACE}", "{SPACE}"

but I do not write macros so it could need tweaking. Copied and modified from:

https://docs.microsoft.com/en-us/office/vba/api/excel.application.onkey

POINT TO REMEMBER: once run, it doesn't just end so you'd need a second macro to end it by remapping the Shift-Space ("+{SPACE}") back to being Shift-Space after you are done.

A non-literal way ("living with it with less suckage" or "workaround") would be to hit the CapsLock key before creating such formulas. Then the space will just be a space. Only an issue in case of needing to type non-cap text, then its "which sucks more?" Or in having to remember to do it each time.

(Each approach has something you have to do then undo when done, never forgetting.)

phuclv
  • 30,396
  • 15
  • 136
  • 260
Jeorje
  • 9