| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Cell Formulas
I have 20 Columns with the simple formula =SUM (A1:A12), =SUM (B1:B12) etc.
I want to change the A1 in each cell to (A5:A12). Can the A1 be changed to A5 in multiple cells without having to change each one individually. Many thanks for any assitance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Multiple Formulas | Excel Discussion (Misc queries) | |||
| Changing cell references in formulas to names and back again. | Excel Discussion (Misc queries) | |||
| Changing multiple formulas at one time | Excel Worksheet Functions | |||
| Problem with formulas changing cell reference | Excel Discussion (Misc queries) | |||
| Changing Cell References in Formulas | Excel Worksheet Functions | |||
Threaded Mode
