To add a new column in the excel worksheet.Ĭlick in a cell to the left or right of where you want to add a column. If the user wants to add a column to the left of the cell, then follow the below process: The user can insert a new column in any version of Excel in the above examples, we can see that we had selected one or more columns in the worksheet then > Right click on the selected column> then clicked on the Insert button. Step 3: One drop-down will be open click on the Insert Sheet Columns.Īs the user wants to use the Insert toolbar to insert a new column, as in the above example, it added. Step 1: Go to Worksheet > Select the column’s heading where a user wants to insert a new column. As a result, it will move B, C, and D column data to the next column, which are E, F, and G it will take the place of the B, C, and D column. Step 3: Now Right-click and select Insert button or use shortcut Shift + Ctrl + +Īs we can see, as it was required to insert a new column left of the B, C, and D column, we added a new column in the above example. Step 2: A user has selected the B, C, and D columns where he wants to insert a new column Step 1: Select B, C, and D columns where a user wants to insert new 3 columns in the worksheet (The new column is inserted to the left of the selected column, so select accordingly) A user wants to insert three columns left of the B column. Let’s take the same data to analyze this example. So, as a result, it will move the D column data to the next column, which is E, and it will take the place of D. As we can see, as it was required to insert a new column between C and D column, in the above example, we have added a new column.
0 kommentar(er)
