Keyboard Shortcut for Name Box

jsfiction

New Member
Joined
Aug 22, 2013
Messages
2
Hi,

I would like to have a keyboard shortcut which moves the cursor into the Name Box to:
- enter a new name or address for selected range,
- copy the address/name of selected range.
Just like when you use mouse to reach the Name Box, it sets the focus and selects its content.

I'm trying to use Chip Pearson's macro: Defined Name Box Shortcut.

Using this code I do can move cursor into the Name Box (I can type a name or a address) but when focus is set into the Name Box the content of the Name Box has disappeared.

Is it possible to keep and select automatically Name Box content using Chip Pearson's solution?

I'm using Excel 2010 32bit, Windows 7 SP1 64bit.
 

Some videos you may like

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

healey21

Well-known Member
Joined
Dec 22, 2009
Messages
900
Welcome to the forum have you tried this:

Select your range of data then use Ctrl + Shift + F3 which will name the selected range with suggestions for you.
 

jsfiction

New Member
Joined
Aug 22, 2013
Messages
2
Welcome to the forum have you tried this:

Select your range of data then use Ctrl + Shift + F3 which will name the selected range with suggestions for you.
Hello. Thanks but Ctrl + Shift + F3 opens a new window Create Names from Selection and I can do it easily with Chip Pearson's macro, it's not a problem. The problem is to copy the text visible in Name Box using only keyboard.
 

Ajay Anand

New Member
Joined
Dec 28, 2018
Messages
1
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
 

Haui

Board Regular
Joined
Apr 5, 2009
Messages
201
Just wondering where is ALT + F3 even documented as a shortcut?
It doesn't appear when googling in any ever so extensive shortcut list or website, isn't listed in the excel help on shortcuts either and at least until Excel 2016 didn't even exist.
 

Watch MrExcel Video

Forum statistics

Threads
1,098,976
Messages
5,465,763
Members
406,449
Latest member
cubeincube

This Week's Hot Topics

Top