View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David McRitchie
 
Posts: n/a
Default named cell range

Hi Marilyn, (just noticed it was answered already, more detail anyway)
Manually, using the name box at the left of the address bar is a
shortcut to using Insert (menu), Define, Name, Define
you should be able to figure it out if you use the menu.

to delete a named cell range
Insert, Name, Define,
select the name you want to delete and use the delete button

to change an existing defined name
Insert, Name, Define
select the name and change its range (at the bottom), OK button

If you reselect the range you want and give it an existing defined name
the new definition will replace the old definition (try it)
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Marilyn" wrote...
In Excel 2002, I want to delete a named cell range and also to edit (change
the rows or columns in a previously named cell range on the same workbook.