• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part 3. Editing Worksheets > Inserting and Deleting Columns

Inserting and Deleting Columns

After you click a cell to the left of which you want to add a column, open the Insert menu and choose Columns.

A new column is inserted (notice the Insert Options Format Painter smart tag, which allows you to format the column like the one to its left, to its right, or to apply no formatting).

To delete a column, right-click the column heading of the column you want to delete, and choose Delete from the shortcut menu that appears.

The column is deleted.

INTRODUCTION

You can insert extra columns into a worksheet to make room for more data or formulas. Adding more columns, which gives the appearance of adding space between columns, can also make the worksheet easier to read. Alternatively, you might want to delete columns from a worksheet to close up some empty space or remove unwanted information.


TIP

Automatic formula column updates

When you insert a new column, Excel automatically updates any formulas affected by the insertion (see Part 5 for more information).


TIP

#REF! error

If the #REF! error appears in a cell after you delete a column, it means you deleted a cell contained data that your worksheet needs to calculate a formula. To resolve the problem, undo the recent change.


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint