Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I recently named the columns in a spreadsheet full of formulas. I then used
InsertNameApply to update my cell references with the names. E.g. if the formula in A13 references C13 and I named column C €śProfit€ť; A13 now references €śProfit€ť instead of C13. I want to reverse the process and change the references back to the way they were. E.g. I want to change €śProfit€ť back to C13. All formulas operate on the same row but in different columns. E.g. the formula in B17 references other columns, but always row 17. Please help me change my formulas back to cell references instead of names. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
column names - chane from numbrts back to A- z | Excel Discussion (Misc queries) | |||
copying cell names | Excel Discussion (Misc queries) | |||
How do you apply Names in formulas? | Excel Discussion (Misc queries) | |||
Replace range names with cell references? | Excel Worksheet Functions | |||
sheets back to formulas | Excel Discussion (Misc queries) |