Inserting a lot of columns or rows in Microsoft Excel is awkward and prone to mistakes. When you need to enter dozens or more columns, use this VBA procedure for ease and accuracy.

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.

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.

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.