In our ms video Salary Sheet | MS Excel salary sheet in Bangla one of our student asked that, How to add columns in existing sheet in Excel.

In the example image, i want to add a column beetwen B & C column .

In our example below, we will show that how to solve that. 

Solution:

Adding columns in our worksheets might just be one of the most basic tasks that we do in Excel.  

Add a column in Excel is by using the right-click menu. 

Follow these steps:

• Select a column to the left of which you want to insert a new one. To highlight the entire column.
• Right-click on the selected column to open the menu.
• Choose Insert from the menu options.

Done! A new column will be added to the left of the selected column

You can also right-click the cell in a column to insert a new column.

Say, we want to add a column between columns C and D.

• Right-click on cell C3.
• Then click Insert from the menu.
• Click the Entire column option.

Finally, click OK.  A new column will be added to the left of the selected column

if you want to learn full MS Excel Visit MS Excel Full Course

0 Votes