Tutorials

Tutorials

editors (login required)
Contents Math Bundle - Elementary Add, Delete, or Resize a Row or Column
Grade: K-12
Required products: Tool Factory Spreadsheet
Instructions
Knowing how to manipulate the columns and rows in your spreadsheet is a very important aspect to organizing data.

Add a Row
Step 1 - Click in the cell you would like to add a row beneath or above.

Step 2 - Press CTRL+Enter on your keyboard or click Spreadsheet>Insert Row on the Menu bar. Alternately you can click the Add Row button on the Spreadsheet toolbar.

Add a Column
Step 1 - Click in the cell you would like to add a column to the left or right of.

Step 2 - Press CTRL+Tab on your keyboard or click Spreadsheet>Insert Column on the Menu bar. Alternately you can click the Add Column button on the Spreadsheet toolbar.

Delete a Row or a Column
Step 1 - Select the rows or columns that you wish to delete by clicking on the number or letter headings on the edge of the spreadsheet.

Step 2 - You can either press Backspace or Delete on the keyboard or click the Delete Row or Delete Column button on the Spreadsheet toolbar.

Resize a Row or Column
Step 1 - Put your mouse on the line beneath or beside the individual row or column that you wish to resize.

Step 2 - Left click, hold, and drag your mouse to resize the column or row.

Adding these skills to your spreadsheet arsenal will greatly increase your spreadsheet skills!
Downloadable Worksheets
  • Print Instructions on Add, Delete, or Resize a Row or Column (DOC)
  • Print Instructions on Add, Delete, or Resize a Row or Column (PDF)
    Mac users: To download, ctrl-click on the worksheet and choose "save link to disk"
  • Click images to enlarge