The process to learn how to add a column in Excel is mercifully simple. Though there are tools in Excel that are difficult to learn, and excruciating to master, column additions are fortunately some of easier tasks you will undertake.
To add a column in Excel, you will need:
- Microsoft Excel
- Planning. Decide where you want your new column. Select (click on) the column to the right of your desired addition.
- Execution. Right click on your selected cell and then click "insert." A new prompt will pop up, giving you a few insertion options. Pick "Entire Column" and click "OK." Congratulations! You have added a new column in Excel!
- Additional Columns. Want to add more than one column? If, for example, you want to add three columns, select the three columns to the right of your desired addition. When you choose "Entire Column" again, three new columns will be added to the left of the selected columns. Your original data will stay together and intact.
- New Features. If you have Excel 2007, you have another easy access option that many people choose to use to add a column in Excel 2007. On the Ribbon, be sure that the "Home" tab is selected. Near the upper right of the screen, click in the "Insert" button, followed by the "Insert Sheet Columns" menu item. The functionality here is exactly the same as the right click method.
Breathe a sigh of relief. You have added a column in Excel, and are on the path towards true Excel mastery.
What Others Are Reading Right Now.
Acting, comedy and strong spirits converge in Speakeasy. When host Russell Peters interviews entertainers about all sorts of topics, neither the drinks nor the conversation is wate …
10 Kung Fu Movies Every Man Should See
From the absolute classics to the so-bad-they're-amazing.
How to Turn (Almost) Every Lady’s Head
Top female stylists share their favorite men’s looks.