How to Add Columns in Excel extremely simple. However, not everyone knows how to do it. As a result, Blog Thiên Minh will show you how to do it in detail below. Please follow us to learn more about how to insert more detailed columns in Excel.

How to Add Columns in Excel with Keyboard Shortcuts

You can completely add new columns of data in Excel with keyboard shortcuts. If you don’t know how to do it, you can refer to the following steps:

Step 1: Click on the letter of the data columns to add. You can also press the keyboard shortcut Ctrl + Space.

With Ctrl + Space then Ctrl Shift + you have inserted a column on the left side

2nd step: You press the keyboard shortcut Ctrl Shift + . In addition to using keyboard shortcuts, you can click on the data column and select Insert from the menu.

With just 2 steps above, you can immediately insert a new column in your Excel sheet. The way to do this is very simple. You must therefore apply immediately.

Add columns in Excel table with table columns on the left

Besides adding columns with the above shortcuts, you can use the traditional method of adding columns in an Excel sheet. Accordingly, you need to click on the table columns on the left to do so. The steps are also very simple. So do it now.

You select the column you want to add in the excel sheet, then right click and select insert and click table columns on the left. With a few simple steps above, you will immediately have a new column inserted to the right of the column to be inserted.

Add columns in Excel table with single table columns on the left

This implementation only allows the implementor to add 1 column. If you add two columns at the same time, the columns to be added will be grayed out. You can also use this method to add non-contiguous rows.

How to add multiple non-adjacent columns in an Excel sheet

If you don’t know how to add multiple non-adjacent columns in an excel sheet, you can do it with us in the following way:

Step 1: You select the non-adjacent columns that you want to insert new columns in the Excel sheet.

You select the non-adjacent columns to add to the excel sheet

2nd step: Point the mouse arrow anywhere in the selection and right-click. When the insert appears, hold down the Ctrl key and left-click. Two new columns will be added to the left of the column you selected.

Hold the Ctrl key and select insert two new columns will be added to the left of the selected columns

How to add columns in Excel with non-adjacent columns has been applied and succeeded by many users. No matter how many non-adjacent columns you need to add, you can easily follow the steps above.

How to add a new contiguous column to an Excel sheet

Besides adding non-adjacent columns above, Excel also helps you to add adjacent columns. It’s also very easy to do. Please apply more columns to the Excel sheet below:

Step 1: You select the columns you need to add to the Excel sheet by holding down the Ctrl key and left-clicking on those adjacent columns.

You select adjacent columns to add new columns

2nd step: You choose to right click anywhere on the columns you just selected.

You right click on the selected columns to show the insert

Step 3: You press the keyboard shortcut Ctrl Shift + or right-click insert to add new columns to the left of the selected columns.

After selecting insert new columns will be added to the left of the selected columns

If you need to add more columns, please follow the steps above. Of course, you will successfully add columns to the Excel sheet.

here are the details how to add columns in excel. Each different way of adding will suit different cases. Therefore, when you need to add columns to Excel table, please refer and apply the above methods to do it.