| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Changing cell addresses to recently added names in existing formul
Filled several cells with formulae that uses data from various cells.
Subsequently assigned names to the data cells. Formulae still reflects column+row addresses. Is there an easy way to update all of the cells with formulae to reflect the assigned names as opposed to the cell address? Relatively new to this site - enjoy reading the solutions to the questions posted. Thanks to all who take the time to respond with help for those of us in need. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Names and addresses | Excel Worksheet Functions | |||
| Existing form in excel; added a combo box; tabbing wrong now | Excel Discussion (Misc queries) | |||
| Excel could not save all the data and formatting you recently added | Excel Discussion (Misc queries) | |||
| Excel could not save all the data and formatting you recently added | Excel Worksheet Functions | |||
| Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
Threaded Mode
