Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Cells (Ranges)
If I name a cell, and want to change the name, in Excel 2003, there is no
easy way to do it. Do I have to delete the name, and add back a new one? Very tedious... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Cells (Ranges)
You do, unless you Get hold of Jan Karel Pieterse's NameManager utility,
http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp. -- __________________________________ HTH Bob "Derek Hart" wrote in message ... If I name a cell, and want to change the name, in Excel 2003, there is no easy way to do it. Do I have to delete the name, and add back a new one? Very tedious... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Cells (Ranges)
Hi,
Actually you don't need to delete the old range name, just add the new name. A range can have as many names as you like. Of course that clutters up the list, but you can come back at some later time and delete unwanted names. -- Thanks, Shane Devenshire "Derek Hart" wrote: If I name a cell, and want to change the name, in Excel 2003, there is no easy way to do it. Do I have to delete the name, and add back a new one? Very tedious... |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Cells (Ranges)
Just to add...
Be careful before you delete the old names. You'll want to change anything that uses them--formulas, other names, VBA code... ShaneDevenshire wrote: Hi, Actually you don't need to delete the old range name, just add the new name. A range can have as many names as you like. Of course that clutters up the list, but you can come back at some later time and delete unwanted names. -- Thanks, Shane Devenshire "Derek Hart" wrote: If I name a cell, and want to change the name, in Excel 2003, there is no easy way to do it. Do I have to delete the name, and add back a new one? Very tedious... -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named Cells (Ranges)
That's one way to slow your workbook down, seeing as the redundant names
will all get recalculated every time. -- _______________________________ HTH Bob "ShaneDevenshire" wrote in message ... Hi, Actually you don't need to delete the old range name, just add the new name. A range can have as many names as you like. Of course that clutters up the list, but you can come back at some later time and delete unwanted names. -- Thanks, Shane Devenshire "Derek Hart" wrote: If I name a cell, and want to change the name, in Excel 2003, there is no easy way to do it. Do I have to delete the name, and add back a new one? Very tedious... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named ranges? | Excel Worksheet Functions | |||
Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Discussion (Misc queries) | |||
Named Ranges | Excel Worksheet Functions |