how do I edit a name in the name box

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
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
 
Back
Top