Adding or Deleting Columns

Education is not limited to just classrooms. It can be gained anytime, anywhere... - Ravi Ranjan (M.Tech-NIT)

Adding or Deleting Columns

Inserting a New Column

As mentioned already, Microsoft Excel has columns named from A to XFD with a maximum of 16384. Microsoft Excel allows you to add a column. Actually, you can insert a column on the left side of an existing column. When you do, Microsoft Excel internally removes the very last column to keep the count to 16384.

To add a new column:

  • Right-click the column header of the column that will be on the right side of the new column you want to create, and click Insert
  • Click the column header or any box under  it. On the Ribbon, click Home. In the Cells section, click the arrow under Insert and click Insert Sheet Columns

Insert Sheet Columns

To add more than one column, first select the columns, whether in a range or randomly. Then:

  • Right-click one of the columns (whether one of the column headers or a box of one of the selected columns) that will be on the right side of the new columns you want to create, and click Insert
  • (After selecting the columns,) On the Ribbon, click Home. In the Cells section, click the arrow button Insert and click Insert Sheet Columns

If you select columns randomly (non-adjacent), a new column would be created on the left side of each of the selected columns.

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

 Practical Learning: Adding Columns

  1. Right-click Column Header E and click Insert
  2. Click Column Header C
  3. On the Ribbon, click Home if necessary.
    In the Cells section, click the arrow button under Insert and click Insert Sheet Columns
  4. Press Ctrl + Home 
     
    Inserting Columns
  5. Save the document

Removing a Column

If you find out that you have a column you do not want, you can remove it. To remove a column:

  • Right-click the column header and click Delete
  • Click the column header or any box under  it. On the Ribbon, click Home. In the Cells section, click Delete and click Delete Sheet Columns

Delete Sheet Columns

To delete more than one column, first select the columns, whether in a range or randomly. Then:

  • Right-click one of the columns (whether one of the column headers or a box of one of the selected columns) and click Delete
  • (After selecting the columns,) On the Ribbon, click Home. In the Cells section, click Delete and click Delete Sheet Columns

If no box under the column header has anything, you would not receive a warning and the column would simply be removed. If at least one of the boxes under the column header has a value, you may receive a warning to indicate whether you want to continue with the operation or not.

To undo any of these actions:

  • On the Quick Access toolbar, click the Undo button Undo
  • Press Ctrl + Z

  Practical Learning: Deleting Columns

  1. Right-click Column Header C and click Delete
  2. Press Ctrl + Home