Sometimes, you may want to add a new column after every other column in your existing dataset. Insert New Columns After Every Other Column (Using VBA) The above steps would instantly insert a column to the left of the selected columns.
Select the columns where you want to insert a new column. 
While you can choose to do this one by one, there is a better way.īelow are the steps to add multiple non-adjacent columns in Excel: The above example is quick and fast when you want to add new adjacent columns (i.e., a block of 3 adjacent columns as shown above).īut what if you want to insert columns but these are non-adjacent.įor example, suppose you have a dataset as shown below, and you want to insert one column before Column B and one before Column D. In case you want to insert any other number of columns (say 3 or 4 or 5 columns), you select that many to begin with.
The above steps would instantly insert two columns to the left of Column B.
Select two columns (starting with the one on the left of which you want to insert the columns). Suppose you have a dataset as shown below and you want to add two columns to the left of column B. In case you need to insert multiple adjacent columns, you can either insert one column and time and just repeat the same process (you can use the F4 key to repeat the last action), or you can insert all these columns at one go. This would insert a column to the left of the column where you selected the cell. This will open the Insert dialog box where you can select ‘Entire Column’. Simply right-click on any cell in a column, right-click and then click on Insert. If you’re not a fan of keyboard shortcuts, you can also use the right-click method to insert a new column. Once you have the column selected, you can use Control Shift + to add a new column. It will just add the new column right away.īelow is the keyboard shortcut to select the entire column (once you select a cell in the column): Control + Spacebar (hold the Control key and press the space bar key) When you select an entire column, using the Control Shift + shortcut will not show the insert dialog box. The above steps would instantly add a new column to the left of the selected column.Īnother way to add a new column is to first select an entire column and then use the above steps. 
In the Insert dialog box that opens, click the Entire Column option (or hit the C key).Use the keyboard shortcut Control Shift +.Select a cell in the column to the left of which you want to add a new column.
#Command insert column excel for mac plus
Suppose you have a dataset as shown below and you want to add a new column to the left of column B.īelow is the keyboard shortcut to insert a column in Excel: Control Shift + (hold the Control and Shift keys and press the plus key)īelow are the steps to use this keyboard shortcut to add a column to the left of the selected column:
Insert new columns after every other column. Insert one new column (using keyboard shortcut or options in the ribbon). In this tutorial, I will cover the following methods/scenarios to insert new columns in Excel: Insert New Columns After Every Other Column (Using VBA). Add Multiple New Columns (Non-Adjacent). Insert a New Column (Keyboard Shortcut).
0 kommentar(er)
