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.

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.

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.