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.

Difficulty: Easy

Instructions

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 column, highlight two or more cells in a row.

[teageling]

on 3/25/2009 How to insert a row that is linked to a number of other spreadsheets that also update with a new row?