Inserting Rows and Columns
Hey! Sean Riley has forgotten the column for SST. Will he have to erase the data in the column for Totals and enter the data for SST? No. That won’t be necessary. In Excel, all he has to do is insert a new column.
To insert a new column
1. Select the column named Totals.
2. On the menu bar, click Insert > Column.
A new, blank column will appear to the left of the Totals column.
You can also add a row in the spreadsheet, without disturbing the rest of the data.
To add a row
1. Select the row where you want to insert a new row.
2. On the menu bar, select Insert > Row.
The new row will be added above the selected row.
To delete a row or a column
1. Select the heading of the row or column that you want to delete.
2. On the menu bar, select Edit > Delete.
3. Or, right click anywhere on the selected row or column.
A menu will pop up
4. Choose Delete.
Note: A new row appears below the cell that you selected. A new column appears before the selected cell.