View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default how do I edit a name in the name box

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.


"Craig" wrote:

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