Changing Multiple Cell Formulas

[Guest]

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]

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.

 

[Guest]

Many thanks for the response.

I have tried using the replace option but it only replaces one cell at a time.

 

[Bob I]

Click "Replace All"?

Many thanks for the response.

I have tried using the replace option but it only replaces one cell at a time.

: