Avatar of AndresHernando
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
Microsoft Excel

Avatar of undefined
Last Comment
AndresHernando

8/22/2022 - Mon
ukerandi

press F3
ukerandi

go to View

then click on formula bar
ukerandi

check the image will show how to do
answer.jpg
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
AndresHernando

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

Thanks, --Andres
chwong67

Try Developer tab, select Design Mode
AndresHernando

ASKER
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Rory Archibald

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.
AndresHernando

ASKER
Hi rorya...  yes, I even rebooted the computer.  I'm thinking I'll need to re-install Excel to get rid of this problem.

--Andres
ASKER CERTIFIED SOLUTION
Rory Archibald

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
AndresHernando

ASKER
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
Your help has saved me hundreds of hours of internet surfing.
fblack61