how do I edit a name in the name box

C

Craig

I have been working on an Excel 2007 sheet and want to edit some of the names
in the name box but cant seem to work it out can some-one please help, thank
you
 
T

trip_to_tokyo

In EXCEL 2007 take the following actions:-

Formulas / Defined Names group / Name Manager (pop up window of the same
name should launch) / in here you will find your range names / select the one
you want to change by clicking on it / Edit . . . / change as desired and hit
OK.

If my comments have helped please hit Yes.

Thanks.
 
×

מיכ×ל (מיקי) ×בידן

Hitting Ctrl+[F3] can save you Menu 3 clicks...
Micky
 

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

Sheet Name? 3
Edit text box in 2010 - how? 1
Deleting invisible range names - how? 3
'copy or move' name conflict 3
How Can I remove cells assigned in Box Name 3
Make the Name Box wider? 4
name cross out 1
File name list in the open dialog box. 1

Top