Step 3: In this case, we added an "Expenses" column, and it now shows between Last name and Sales. Mark Coppock/Digital Trends Adding a partial column Sometimes, you want to add a new column to ...

2. Select the column to the right of where you want a new column. (Excel will insert the new column directly in front of it.) Select an entire column by clicking on its letter name at the top. 3.

If you cannot insert, add or create new cells in worksheets in Microsoft Excel, remove cell protection and unmerge the Rows to begin with.

Specficially, Excel inserts rows below and to the right of the selected row or column, respectively. This behavior is in keeping with the fill handle in general.