hotkey for selecting name box

Tim C

New Member
Joined
Oct 7, 2002
Messages
42
Is there a hotkey for selecting the name box or another method of selecting it other than the mouse?

Thanx.

Tim C.
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Tim C

New Member
Joined
Oct 7, 2002
Messages
42
Thanks but I mean if your looking at your spreadsheet, somewhere at the top left corner, there is the name cell.. you can click on it and change the name of a cell.. I'd like to be able to access that area with having to click on it.. is there a way in doing so?
 

Tim C

New Member
Joined
Oct 7, 2002
Messages
42
Basically, I want to retrieve the contents located in the Name cell.. if you use the drop down box, you will see defined names that the work sheet has already but normally, the box will show the name of the cell your currently on.. I want to be able to select the name box and copy that information for other use..
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654

ADVERTISEMENT

The Define Name list is a superset of what's listed in the Name Box.
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Go To.... doesn't allow you to "...click on it and change the name of a cell".
 

Watch MrExcel Video

Forum statistics

Threads
1,122,694
Messages
5,597,571
Members
414,156
Latest member
WDMix

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top