Inserting the new column shifts the cells in the same row to the right and makes space for your new data. Click a column heading to the right of where you want to insert the new column of blank cells.

You can add a column in Excel by right-clicking or using the “Insert” option. These features are helpful for adding new data to a spreadsheet.

How to insert rows in between other rows in Excel If you want to insert a blank row between every other row, you're going to need what's known as a helper column.

Fix Microsoft Excel can’t insert new cells because it would push non-empty cells off the end of the worksheet error the right way.