Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named cell range
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
named cell range
Hi
Go to: Insert/Name/Define and you will get a table showing current ranges/names. Andy. "Marilyn" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unique identifier | Excel Discussion (Misc queries) | |||
cell address rather than range name | Excel Discussion (Misc queries) | |||
How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Define a range based on another named range | Excel Worksheet Functions |