Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default 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   Report Post  
Posted to microsoft.public.excel.misc
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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,520
Default 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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 561
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA edit Benjamin Excel Discussion (Misc queries) 1 April 25th 08 04:58 PM
Edit? Office Lapis[_2_] Excel Discussion (Misc queries) 3 August 19th 07 11:12 PM
F2 Edit Key dr Excel Worksheet Functions 0 August 8th 07 07:44 PM
fx-edit teddkilroy New Users to Excel 1 April 3rd 06 05:58 PM
Why can't I edit my excel document? Edit buttons shaded. Arl @ CBC New Users to Excel 3 September 7th 05 01:18 AM


All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright 2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"