How to Insert a Column Using Excel

Microsoft Excel allows you to organize, format, and calculate data by using formulas in a spreadsheet. The data is formatted using columns and rows. A simple process that you can benefit from is learning how to insert columns in an Excel spreadsheet. You can also do other simple tasks like hiding and deleting columns.

Single Column:

1. Right click on the column header where you would like to place the new column.


2. Choose the “Insert” button.


3. Begin using your newly input column.

Multiple Columns:

1. Select the number of columns you would like to add to add in the column header.


2. Right click on the selected columns.


3. Choose the “Insert” button.


4. Begin using your newly input columns.

Delete Columns:

1. Select all of the columns you want deleted from your worksheet.


2. Right click on the selected columns.


3. Choose “Delete” from the menu, and the columns will be deleted.

Hide Columns:

1. Select the columns in the column header, and highlight the columns you want to hide.


2. Right click on the selected columns.


3. Select “Hide” from the menu, and the selected columns will be hidden from plain eyesight.