![]() 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 +. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |