How to Add Columns in Microsoft Excel

How to Add Columns in Microsoft Excel

In this article, I am going to cover the topic of how you can add a column in Microsoft Excel. So, follow below some of the simple and very steps to know how to use this function.

There are many ways to use this function, you can use shortcut keys, add columns manually, and others. So, to know the shortcut key and ways to add columns follow below some very easy steps.

Add Columns in MS Excel

Step 1: The very first step is to open your spreadsheet where your data is stored or create dummy data to perform this function or test.

Step 2: Select the Columns, in my case I have selected Column A.

Step 3: Now, right-click on your mouse and click the Insert option.

Step 4: See below the result.

If in case, you want to add multiple columns at a time then follow below the simple steps.

Step 5: For this, you need to select multiple columns for example, in the below image I have selected two columns which are Column A and B.

Step 6:  Now, follow the same step as step 3, right-click and click on the Insert option.

Step 7: See below the result.

Also Read: How to Hide and Unhide Columns and Rows in MS Excel

Also Read: How to lock cells in excel

You can also use this function from the Home tab. To know this, follow the below easy steps.

Step 1: In your spreadsheet drag and select the Columns from A to D, as I have selected in the below image.

Step 2: Now, go to the Home tab, and click on Insert in the group of cells, under Insert click on Insert Sheet Column. Shortcut key (Alt + H + I + C).

Step 3: See below the result.

If you want to add columns more quickly then just press CTRL SHIFT +.

Leave a Reply

Your email address will not be published. Required fields are marked *