Link to home
Start Free TrialLog in
Avatar of AndresHernando

asked on

Excel Name Box is locked!

I cannot get into the Excel "name box" in the top left, where named ranged appear.
I used to be able to get in by simply double-clicking in it, but now I can't.  It appears to be locked.
How can I "unlock" this so I can get into it like I used to?

Thanks, --Andres
Avatar of ukerandi
Flag of United Kingdom of Great Britain and Northern Ireland image

press F3
go to View

then click on formula bar
check the image will show how to do
Avatar of AndresHernando


ukerandi, the formula bar is visible (with the NameBox).  However, I cannot access it.

Thanks, --Andres
Try Developer tab, select Design Mode
chwong67, design mode in Developer tab didn't do it.  Thanks, though.

It's very strange...  the Name Box was working fine and now I'm locked out of it.  Very annoying.
Is this with all workbooks? Have you restarted excel? The only time I see the name box locked is if you are in edit mode or Excel is awaiting a response to something.
Hi rorya...  yes, I even rebooted the computer.  I'm thinking I'll need to re-install Excel to get rid of this problem.

Avatar of Rory Archibald
Rory Archibald
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
WOW!!!!!  If I click on the VERY far left it works fine like you said.  If I click farther to the right it's "dead'.

You da man, rorya!   This was driving me nuts.  Thanks!!!!  --Andres