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.

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

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.

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.