Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rename a cell
I am sure this has a simple answer, but I can't figure it out.
I have a spreadsheet that contains 12 months worth of budgets. The upper left corner of the spreadsheet is NAMEd according to that month/year of the budget, ie JAN06 - DEC06. I copied several months worth of budgets to a new sheet and the same NAME was copied too. I tried to rename the appropriate cells, JANO6 renamed to JAN07 and so forth. However, I cannot get it to take the new name. I have tried clicking in the box to the left of the fx window. I have tried via NAMEDEFINE, but cannot get the new name to take. Any suggestions? Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rename a cell
If a cell or range is named, you can change the range that name refers to by
Insert Name Define and alter the range accordingly. However you can't change the 'name' of a named range unless you first delete the existing named range and then define a new one. In other words, delete the existing named ranges and create new ones. Regards, Alan. "WLMPilot" wrote in message ... I am sure this has a simple answer, but I can't figure it out. I have a spreadsheet that contains 12 months worth of budgets. The upper left corner of the spreadsheet is NAMEd according to that month/year of the budget, ie JAN06 - DEC06. I copied several months worth of budgets to a new sheet and the same NAME was copied too. I tried to rename the appropriate cells, JANO6 renamed to JAN07 and so forth. However, I cannot get it to take the new name. I have tried clicking in the box to the left of the fx window. I have tried via NAMEDEFINE, but cannot get the new name to take. Any suggestions? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
copying cell names | Excel Discussion (Misc queries) | |||
up to 7 functions? | Excel Worksheet Functions |