How do I add a column in Excel?
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, simply do the same thing, only with the row numbers to the left of the spreadsheet.
[…] of splitting column B (or splitting any of the cells in column B) you need to insert a new column between columns B and C. To do this you need to select column C by clicking on the grey C at the […]