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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Cell Formulas
You mean A1 should become A5, b1 should be B5, ...
If yes, then you could try this: Select the range to fix edit|Replace what: 1: (1 followed by a colon) with: 5: (5 followed by a colon) replace all Essentially, you're looking for a unique string that occurs in each formula. In this case "1:" fit that need. zephyr wrote: 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. -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Cell Formulas
Many thanks for the response.
I have tried using the replace option but it only replaces one cell at a time. "zephyr" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Changing Multiple Cell Formulas
Click "Replace All"?
zephyr wrote: Many thanks for the response. I have tried using the replace option but it only replaces one cell at a time. "zephyr" wrote: 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. |
Reply |
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 |