Name Box Keyboard Shortcut

**Maxx57** · 02-17-2010, 04:46 PM

Background Info:
I have to repeatedly create specific names in an Excel worksheet. These worksheets are laid out with specific formatting, so I cannot change the layout or add cells, etc. All I need to do is add cell names, by mouse clicking on a cell (1x1 in size) then mouse clicking in the "name box" then entering the name I want. I then press "Enter" on the keyboard and then "Tab" or "Enter" to go to the next cell I want.

The Problem:
Once I have a cell selected, I cannot use the keyboard to get my cursor into the "name box". I have to use the mouse to click in the "name box". It slows me down. I don't want to use the mouse. Is there a keyboard shortcut that will move the cursor into the name box so I can simply type the name of the cell (essentially naming the cell)? I then press "Enter" or "Tab" to the next cell, hit the shortcut again, then enter the next cell name to define it, repeat that process a gazzillion times. I know there are shortcuts to creating named cells like CTRL-SHIFT-F3, but these names are not what I want. I have very specific names for each cell, not the auto created names that Excel will create for you.

Please Help!!!!! Thank you soooooo much in advace for replying.

Maxx57

**JBeaucaire** · 02-17-2010, 04:52 PM

I use the standard Windows keys for this.

1) Cursor to a cell
2) Press Alt+I, N, D and the Name window is open
3) Type your name and press ENTER

**Maxx57** · 02-17-2010, 06:58 PM

You're awesome!!!! Thanks! I'm not sure why I didn't see that when I was pressing the ALT-I, N, D. Sweet!!! My life just got easier!

**JBeaucaire** · 02-17-2010, 07:20 PM

Yeah, me too, I hate the mouse!

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)