Likewise, we can also insert rows. With the row label (number) selected you must choose the Row from the Insert menu. Again this will insert a row before the row you have selected.


The formulas will be updated to their corresponding locations.
C3 was = C2+B3
NOW C4=C2+B4
The formulas will be updated to their corresponding locations.
C3 was = C2+B3
NOW C4=C2+B4