If you want to learn how to insert a column in Excel, then you’ve landed on the right page.
Spreadsheets make life so much easier for both businesses and members of the public. From managing inventory to keeping track of a monthly budget, Microsoft Excel really does, well, excel! Excel can be quite daunting for new users, however, and they can get confused about even the basic functions such as adding a new row or columns.
If you’re in the same boat, then we’re here to help you learn how you can add columns in Excel.
Using the Insert button
The easiest way to add a new column in Excel is by using the Insert button.
Step
Open your Excel sheet
First, open your Excel sheet in which you want to add a new column.
Step
Select a column
Select a column next to which you’d like to add the new one. Keep in mind that the new column will appear on the left side of the one you select.
Step
Click on Insert
Right-click on any cell within the selected column and select ‘Insert.’
Step
Add a new column
From the options that will appear on the screen, select ‘Entire column’ and click ‘OK.’
Once done, a new column will be added to the sheet.
If you want to add multiple columns in Excel, simply select two or more columns before pressing right-click.
Using the Ribbon
Excel has a bunch of Ribbons that you can use, and one of them lets you quickly add a new column.
Step
Select a column
Open an Excel sheet and select a column.
Step
Click on the Ribbon
Now, go to the Home tab and click on the Insert Ribbon. Then, select ‘Insert Sheet Columns’, after which the new column will appear on the sheet.
Conclusion
This was everything you needed to know about how to add Columns in Excel. As you can see for yourself, the process is pretty simple, and it will hardly take you a few seconds to insert a new row.
If you want to learn more about Excel and how it works, give these in-depth guides a read:
