To run the program from the Run tab > select Run Sub/UserFormĪs a result, a new column will be added to the left of the Name header. ➤ And I have used C2 to refer to the whole Column C. ⇒ In the Sub Shortcut_to_Insert_Column, I have used the “ Entire Column” property and “ Insert” method. Go to Developer tab > select Visual BasicĪfter that, write the following code in the Module. To insert a column to the left of Column C, Now I am going to show how to insert a new column using VBA. To apply this shortcut and add multiple non-adjacent columns, One will be to the left of the header “ Name” and another one to the left of the “ Sales” header. This time, two new columns will appear, but they will not be adjacent to each other. ➢ Then hold the CTRL Key and select column D. To add two columns that will not be adjacent to each other, select column C and column D again. This time you are going to insert two non-adjacent columns in Excel using shortcuts. I’m going to show you two cases here too.ģ.1. Insert Multiple Non Adjacent Columns Using Shortcut You must select column C and column D at once by right clicking and dragging the mouse. Thus two new columns adjacent to each other will be added to the left of the “ Name” column. To insert two adjacent columns to the left of the “ Name” header, select column C and column D at once by right clicking and dragging my mouse. You can also use a keyboard shortcut to insert multiple adjacent columns. Thus you will add two adjacent columns next to the “ Name” column. Or you can hold the CTRL key then select multiple columns. To add two adjacent columns to the left of column C, select column C, and column D at once by right clicking and dragging my mouse. I am going to show two ways to insert multiple adjacent columns by using keyboard shortcuts.Ģ.1. Insert Multiple Adjacent Columns Using Excel Shortcut Because the header “ Name” is in column C.Ģ. To add a column to the left of the “ Name” column, Suppose you want to add a column left to the “ Name” header.Ī new column will be added to the left of the header “ Name”. Here, basically, I am going to discuss two shortcuts that you can apply in your Excel datasheet.ġ.1 Using SHIFT + CTRL + Equal (=) Shortcut You can easily insert a column in your existing dataset as a shortcut. Using Shortcut Keywords to Insert a Column in Excel Each has a unique ID and the amount of sales that they have made is enlisted under the Sales Column.Ĥ Shortcut Ways to Add a Column in Excel 1. Here, the Name indicates the name of the salesmen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |