Would you like to be able to password protect your worksheet so that other people aren’t able to edit it? Find out how to require a password in Excel 2013 and stop people from making changes to your work. If it is protected, then you will need to get the password to unlock it, then click the Review tab at the top of the window and choose the Unprotect Sheet option. If you are unable to complete these steps to add a column, then it’s possible that your spreadsheet is protected from editing. Note that you can also add a column in Excel by selecting the column letter as we did in Step 2 above, then clicking the Home tab, selecting Insert in the Cells section of the ribbon, and choosing the Insert Sheet Columns option. Step 3: Right-click the selected column letter, then choose the Insert option. I want to put the new column between columns C and D, so I am selecting column D. Step 2: Click the column letter to the right of where you wish to add the new column. Step 1: Open the spreadsheet to which you wish to add a new column. Example of How to Group in Excel Select the rows you wish to add grouping to (entire rows, not just individual cells) Go to the Data Ribbon Select Group. This guide assumes that you have an existing spreadsheet, and that you wish to add a new, blank column between two existing columns. The steps in this article were performed in Microsoft Excel 2013, but will also work in most other versions of Excel. How to Add a New Column to a Spreadsheet in Excel 2013 Our tutorial below will show you how to add a column in Excel 2013. Excel suggests that we move our Pivot Table and then insert a column. However, if we select the B column, right-click on it and select insert, we will get an error message: This message tells us that we cannot change these cells because this will affect our Pivot Table. We’re going to apply a formula that tells Excel to take 15 of 83 (or 12.45) and add it to our original. The quickest way is to add a column to our table. Click the empty cell next to your percentage to tell Excel where we’ll be displaying the result of our formula. A, in our example, will be the whole number, while B will be our percentage. Luckily you won’t need to manually copy and paste all of your existing cells to new locations, as you can actually insert an entire column in the middle of an Excel spreadsheet. Insert your two figures in columns A and B. You might need to include another piece of information, and it would make more sense for that new data to be added in a column that is between two of your existing columns. Sometimes you may determine that the data that you have in your spreadsheet isn’t all of the data that you actually need.