Inserting a blank row between existing rows of data in an Excel spreadsheet can be a tedious task if you insert each row individually. Fortunately, if you know this trick, inserting rows between ...

You can insert blanks rows above or below another in Excel, and you can even add them between each row that has data.

Cut and Insert: Shift, Click, and Drag If you want to squeeze the contents of a cell, row, or column between existing data without replacing it, hold Shift as you click and drag it.