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.
|