Right-click a column header that you want to insert a column to the left of (or row header above, if inserting a row), and select Insert from the shortcut menu.
The Insert Options Format Painter smart tag appears with the new column. Click it to format the new column like the one on the left or right, or with no formatting.
Right-click the row header (or column header) that you want to remove and select Delete from the shortcut menu.
The selected row (or column) is deleted.
INTRODUCTION
You can insert extra rows and columns into a worksheet to make room for additional data or formulas or to make the worksheet easier to read. Along with adding rows and columns, you can also delete them from a worksheet to close up empty space or remove unwanted information.
TIP
Automatic Formula Row Updates
When you insert a new row or column, Excel automatically updates any formulas affected by the insertion (see Part 9, "Working with Data and Charts," for more information about formulas).
TIP
#REF! Error
If the #REF! error appears in a cell after you delete a row or column, it means you deleted a cell or cells that contained data your worksheet needs to calculate a formula. To resolve the problem, undo the change and review your calculations.