How to Insert a Row or Column in an Excel Spreadsheet

You don't have to redo the whole spreadsheet if you left out a row or column. Just use the Excel Insert command. These steps are intended for Microsoft Excel 97.

Instructions

Difficulty: Easy

Things You’ll Need:

• Excel Book
• Microsoft Excel

Inserting a New Row

1. Start Microsoft Excel, and open the file you want to change.
2. Click on the cell immediately below where you want the new row to appear.
3. Open the Insert menu, and select Rows. The new row will appear above your current selection.

Inserting a New Column

4. Start Microsoft Excel, and open the file you want to change.
5. Click on the cell immediately to the left of where you want the new column to appear.
6. Open the Insert menu, and select Columns. The new column will appear to the left of your current selection.

Tips & Warnings

• To add more than one row, highlight two or more cells in a column.
• To add more than one column, highlight two or more cells in a row.

Who Can Help:

• Find Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.
• Find Electrical Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.