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.
Other People Are Reading
Instructions
-
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.
-
1
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.
More Like This
Comments
-
How do I insert a cell - I'm tearing my hair out - Please don't tell me to go to INSERT button as there is no provision for cells.
-
teageling
Mar 25, 2009
How to insert a row that is linked to a number of other spreadsheets that also update with a new row? -
teageling
Mar 25, 2009
How to insert a row that is linked to a number of other spreadsheets that also update with a new row?
