Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Editing cell names
Is there any means of editing a vast number of cell names within a
spreadsheet without having to resort to Insert - Name - Define and editing each one separately? I have a spreadsheet with 100s of cells names across the spreadsheet. I now wish to expand the function of my spreadsheet to be able to handle, say, 3 projects within the same spreadsheet, and intend having, say, "price_A", "price_B" and "price_C" in separate worksheets. I am thinking that I have to proceed as follows: 1- starting with template spreadsheet, edit all names to read "cell name_A", and save file as "new multiple project spreadsheet." 2 - revert to original template, edit all names to read "cell name_B" and copy that worksheet into the "new multiple project spreadsheet." 3 - repeat 2 for "cell name_C." I will end up with a spreadsheet with three cells named "Total," however these will be Total_A, Total_B and TotalC. If there's no quick way, then I have to rename all one at a time! Using Excel 2003 on XP Professional 2002 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In cell editing | Excel Discussion (Misc queries) | |||
Editing a list of names that have numbers- Can i take out the numb | Excel Worksheet Functions | |||
Cell names = sheet names | Excel Worksheet Functions | |||
Editing in Cell | Excel Discussion (Misc queries) | |||
Cell Editing | New Users to Excel |