How to Insert a Row or Column in an Excel Spreadsheet

By eHow Computers Editor

Rate: (7 Ratings)

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:

Inserting a New Row

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

Inserting a New Column

Step1
Start Microsoft Excel, and open the file you want to change.
Step2
Click on the cell immediately to the left of where you want the new column to appear.
Step3
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.

Post a Comment

POST A COMMENT

Request a New How-To Article

Looking for more How To information? Chances are there’s an eHow member who knows how to do what you’re looking to do. Submit an article request now!

eHow Article: How to Insert a Row or Column in an Excel Spreadsheet

eHow Computers Editor

eHow Computers Editor

Category: Computers

Articles: See my other articles

Related Ads