Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change named cells and keep the links
Hi!
I would like to know if there is any way to change the name of an allready named cell without modifing the links. example: B6 is named 'green' and is =2 then if write in another cell, for example C7, =green+1 instead of writing =b6+1 if I change the B6 name 'green' for 'chair' how can I make that all the related cells, C7 for example, change 'green' for 'chair'. I wish my doubt is clear. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Change named cells and keep the links
Thanks Tom!
"Tom Hutchins" wrote: One way... Select all the cells on the sheet (press Ctrl+A). Select Replace from the Edit Menu. Find what: green Replace with: chair Click Replace All, then Close. If you have formulas referencing green on other sheets, you will have to change them also. "BCN" wrote: Hi! I would like to know if there is any way to change the name of an allready named cell without modifing the links. example: B6 is named 'green' and is =2 then if write in another cell, for example C7, =green+1 instead of writing =b6+1 if I change the B6 name 'green' for 'chair' how can I make that all the related cells, C7 for example, change 'green' for 'chair'. I wish my doubt is clear. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Named sheet to change Cells names | New Users to Excel | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
#REF on Links to Named Range in External Workbook | Excel Discussion (Misc queries) | |||
Cell just shows formula after named region var change | Excel Worksheet Functions | |||
Named range links to external workbook, help! | Charts and Charting in Excel |