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
Sometimes we (all) make mistakes or things change. If you have a spreadsheet designed and you forgot to include some important information, you can insert a column into an existing spreadsheet. What you must do is click on the column label (letter) and choose in Columns from the Insert menu. This will insert a column immediately left of the selected column.
As you can see from this example there was a blank column inserted into the spreadsheet. You might wonder if this will affect your referenced formulas. Yes, the Referenced cells are changed to their new locations. For example:
Cell C4 was =C3+B4
and now is =D3+B4
No comments:
Post a Comment