Is there a keyboard shortcut to get you into the Name Box? (the left-most field in the Formula Bar).
If not, is there a way to create one? I use that field all the time, and I hate picking up my mouse to write in it.
Is there a keyboard shortcut to get you into the Name Box? (the left-most field in the Formula Bar).
If not, is there a way to create one? I use that field all the time, and I hate picking up my mouse to write in it.
Re: Name Box Shortcut Key
Ctrl-F3
Re: Name Box Shortcut Key
Thanks--I realized that what I was after is the same as the Go To dialog: Ctrl + G
[SIZE=14px]I think F5 (or Ctrl+G) is the most useful [/SIZE][SIZE=14px]work around[/SIZE][SIZE=14px] to go to the Name box directly in Excel [/SIZE][SIZE=14px]till[/SIZE][SIZE=14px] Ver 2016.[/SIZE]
[SIZE=14px]I think F5 (or Ctrl+G) is the most useful [/SIZE][SIZE=14px]work around[/SIZE][SIZE=14px] to go to the Name box directly in Excel [/SIZE][SIZE=14px]till[/SIZE][SIZE=14px] Ver 2016.[/SIZE]
Did something change in Ver 2016? If so please enlighten me. Thanks.
ALT + F3 is the shortcut to Excel Name Box
CTRL + F3 for Name Manager
CTRL + SHIFT + F3 for Creating Names from Selection
F3 for Paste names dialog Box
Don’t have an account yet? Register yourself now and be a part of our community!