Add Column in Excel: How to Delete, Add Columns in Excel

This updated guide examines Add Column in Excel: How to Delete, Add Columns in Excel and organizes the essential facts, background, and practical takeaways in clear American English.

1. Instructions to add Excel columns

Method 1:

Click on the current column position and right click, select Insert . With the addition of a column in Excel, the new default column will always be left with the column that is clicking.

Immediately a new column E was displayed on the left hand side of the original column F that was clicked. The original mouse column will push to the right.

Method 2:

In any cell in a column that users want to add a new column to the left, press the right button and select Insert .

Display a new dialog box with various options, we click on Entire Column to insert a column in Excel. And the result also shows a new left column at the mouse column click.

Note that if you want to add more than 1 Excel column, you need to select 2 existing columns or highlight 2 cells of 2 adjacent columns to add 2 new columns on the left, with the same method.

2. How to delete columns in Excel

To delete any column in Excel, we select the column and right-click , then click Delete to delete theExcelcolumn is finished. Or, click the column and then press Ctrl + - to delete the Excel column.