spreadsheets

Deleting or Adding Columns or Rows

You can get rid of unwanted data or other information by deleting rows or columns.

For example, in our sample spreadsheet of weapons used in homicides, we might want to get rid of row 23, which is just a footnote stating that one murder in which the victim was pushed to his/her death has been included in the "Personal weapons" listing in row 14.

row 23 in a spreadsheet

To delete a row, hover your mouse cursor over a row number in the gray area to the left, in this case row 23. Right click and in the pop-up menu select Delete row.

deleting a row in a spreadsheet

Use the same procedure for deleting a column.

Hover your mouse cursor over a column letter in the gray area at the top, right click and in the pop-up menu select Delete column (you also can click on the tiny downward-pointing arrow to get this pop-up menu).

If you want to add a column or row, again hover your mouse cursor over the appropriate column or row in the gray area above or to the left, right click and in the pop-up menu select one of the Insert options.