Excel Name Box is locked!

AndresHernando
AndresHernando used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
press F3

Commented:
go to View

then click on formula bar

Commented:
check the image will show how to do
answer.jpg
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

Author

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

Thanks, --Andres

Commented:
Try Developer tab, select Design Mode

Author

Commented:
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.
Most Valuable Expert 2011
Top Expert 2011

Commented:
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.

Author

Commented:
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
Most Valuable Expert 2011
Top Expert 2011
Commented:
Where exactly are you clicking? There are dead spots on the right hand side of the name box in my experience, but the left hand side should always work.

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial