Inserting and Deleting Columns and Rows
To insert a Column/Row:
Click on the columns or row identifier to the left of the row/top of the columns (i.e. the columns letter or row number):
Click on the insert menu and select Columns or Rows
The new column/wow will be inserted at the point selected.
Multiple columns/rows can be inserted by selecting the required number of columns/rows before clicking on the insert menu.
To delete a Column/Row
Select the Column/Row as above
Click on the Edit menu and select Delete
Exercise
Insert a new Row for an Expenditure item of your choice
Insert a new Column for May
Enter some values into the new Row and Column
Use Autofill to copy the sum function to the new total cells
Check to see that the Formula Bar is showing the correct cell ranges, i.e. the new cells have been included in the Total figures.
