J
John Google
Hi,
Suppose I have a simple spread sheet where A1-A4,B1-B4 and C1-C4 have
various numbers.
A5 has the formula = SUM(A1:A4). B5 and C5 have similar formula to sum
their rows.
I now have a simple question.
I want to insert 4 rows after row 4 to enter new data into the 3
columns (12 cells). The formula which was in A5 will be moved to A9
(similar for cols B and C).
I can enter the rows OK by selecting 4 rows from A5 to A8 then
selecting the menus Insert / Rows.
However, when I do this, the formulae still refer to =SUM(A1:A4) and
not =SUM(A1:A8).
What is the best way to insert rows and adjust the formulae
automatically?
Thanks!
Suppose I have a simple spread sheet where A1-A4,B1-B4 and C1-C4 have
various numbers.
A5 has the formula = SUM(A1:A4). B5 and C5 have similar formula to sum
their rows.
I now have a simple question.
I want to insert 4 rows after row 4 to enter new data into the 3
columns (12 cells). The formula which was in A5 will be moved to A9
(similar for cols B and C).
I can enter the rows OK by selecting 4 rows from A5 to A8 then
selecting the menus Insert / Rows.
However, when I do this, the formulae still refer to =SUM(A1:A4) and
not =SUM(A1:A8).
What is the best way to insert rows and adjust the formulae
automatically?
Thanks!