Why is the menu item "Insert - Name" greyed out?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I go to the Insert menu item and try to select Name, it is grey and I
can't select it. Why?
 
If the sheet is not protected try to reset the menu

Tools>Customize
select insert
right click on name
select reset

if that does not work and you don't have a macro you might want to do a
search for *.xlb and rename it and restart excel
 
Another consideration is to make sure you are not in Edit mode. That is one
of the things you cannot do if you have a flashing insertion point in a cell.
(Just in case you were trying to insert a range name into a formula.)

HTH |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Validation Menu Greyed Out? 5
External Data Toolbar permanently greyed out. 7
WHY IS FREEZE PAINS GREYED OUT 7
Insert menu greyed out 1
When excel is opened, Insert, Format, Data options greyed out. 2
Insert Worksheet "greyed out" 2
trying to draw a text box, but options are grey 1
can't record a new macro or insert module in editor 1

Back
Top