How to add columns in Excel extremely simple. However, not everyone knows how to do this. Therefore, Blog Thien Minh We’ll show you how to do this in detail below. Join us to learn how to insert more detailed columns in Excel.
How to Add Columns in Excel Using Keyboard Shortcuts
You absolutely can add new columns of data in Excel using keyboard shortcuts. If you don’t know how to do it, you can refer to the following steps:
Step 1: Click on the letters of the columns of data you need to add. Alternatively, you can press the keyboard shortcut Ctrl + Space.
With Ctrl + Space then select Ctrl Shift + you have inserted a column on the left
2nd step: Click on the shortcut key combination Ctrl Shift +. In addition to using keyboard shortcuts, you can click on the data column and select Insert from the menu.
With just the above 2 steps, you can immediately insert a new column in your Excel table. The way to do this is extremely simple. Therefore, you should apply immediately.
Add columns in Excel table using left table columns
In addition to adding columns using the above shortcuts, you can use the traditional method to add columns in an Excel table. Therefore, you need to click on the table columns on the left to do so. The steps are also extremely simple. So do it now.
Select the column you want to add in the Excel table, then right-click, select insert and click the table columns on the left. A few simple steps above will immediately give you a new column inserted to the right of the column to be inserted.
Add columns in Excel table using simple left table columns
This method only allows the user to add 1 column. If you add two columns at the same time, the columns that need to be added will be grayed out. Additionally, you can use this method to add rows that are not adjacent.
How to add multiple non-adjacent columns to an Excel table
If you don’t know how to add multiple columns that are not adjacent to each other in an Excel table, you can do it with us in the following way:
Step 1: You select the non-adjacent columns in which you want to insert new columns in the Excel table.
You select non-adjacent columns to add to the Excel table
2nd step: Adjust the mouse arrow to point where the selection is and right-click. When the insert appears, hold Ctrl and left-click. Two new columns will be added to the left of the column you selected.
Hold Ctrl and select Insert two new columns will be added to the left of the columns you select
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 do it by following the steps above.
How to add new adjacent columns to Excel table
In addition to adding non-adjacent columns above, Excel also allows you to add adjacent columns. How to do it is also extremely simple. Please add columns to the Excel table below:
Step 1: You select the columns you need to add to the Excel table 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 view the insert
Step 3: 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, follow the steps above. You will surely succeed in adding columns to the Excel table.
Above details how to add columns in Excel. Each different addition method will suit different cases. Therefore, when you need to add columns to an Excel table, please refer and apply the above methods to do so.