Where is "Insert Name" on the menu bar?

C

Chris_Clarke

I have been trying to delete a named range in Excel 2007.

An answer posted says:

From the Excel main menu:
<insert><name><define>
Select the name to be deleted
Click the [delete] button

But I'm being stupid here and can't find the "name" under isert - must
belooking in the wrong place - can someone please point me in the right
direction.

Thanks

Chris Clarke
 
B

Barb Reinhardt

I don't have 2007 here, but I wonder if you have some down arrows at the
bottom of the insert line. If so, click on that. Name may be hidden to you.
 
O

Otto Moehrbach

There is a menu that runs horizontal across the top of the screen. One of
the items in this menu is "Insert". Click on that word. That produces a
drop-down menu. One of the items on that menu is "Name". Click on that
word. That produces another drop-down menu. One of the items on that menu
is "Define". Click on that word. A box appears that displays all the range
names in the file. Find the one you want to delete and click on that range
name. Then click the "Delete" button that is located in that box. HTH
Otto
 
O

Otto Moehrbach

I take back my response. I didn't read the "2007" in your post. These
things are not the same in 2007. Otto
 
R

Roger Govier

Hi Chris

in XL2007, you need to go to the Formulas tab>Defined Names section>Name
Manger
This will give you the opportunity to Create, Edit and Delete Named
ranges.
 
T

Teethless mama

Formulas tab > Name Manager > select the name you wat to delete then hit
Delete button
 
Top