How do I Add a Column in Excel?

How do I Add a Column in Excel?

How do I add a column in Excel? Link to our YouTube video How do I add a column in Excel? - This is a really simple, but apparently it is a commonly searched for problem!  So if you've found this article because you can't add a column then you are not alone. First of all, select the entire column to the right of where you want to insert the new one.  For example, if you wanted to insert a column between columns B and C, then you would click in the grey area at the top of column C (see image below for where you need to click to select an entire column): Once you have selected the column, you then need to right-click in that same place to come up with a context menu, then click "Insert". And that's that, the new blank column appears, what was in Column C now becomes Column D: The exact same technique is used to insert new rows,...
Read More

Sorting by 2 or more columns at the same time

In an earlier blog post we talked about how we can sort our data in Excel and Google Sheets by alphabetical or numerical order.  This was assuming you only wanted to sort by 1 column (e.g. sort a table of personnel records by Name in alphabetical order). But there are times when you will want to sort by 2 or more columns at once.  The technique is largely the same in Excel as it is in Google Sheets, although the menus are in different locations.  In this example we have a table I randomly downloaded from the Office for National Statistics, as we can see there are a number of ways we might want to sort this data: So let’s say for example we want this first sorted by “NUTS level” (whatever that means…) and then by Index from low to high.  First we select the table:  in Excel we click the “Sort & Filter” button in the Home tab and choose...
Read More