Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I edit a name in the name box
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I edit a name in the name box
In XL2007 try menu Formulas'Define Names' Name Manager
-- Jacob "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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I edit a name in the name box
Hitting Ctrl+[F3] can save you Menu 3 clicks...
Micky "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA edit | Excel Discussion (Misc queries) | |||
Edit? | Excel Discussion (Misc queries) | |||
F2 Edit Key | Excel Worksheet Functions | |||
fx-edit | New Users to Excel | |||
Why can't I edit my excel document? Edit buttons shaded. | New Users to Excel |