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.

How to combine values into a single cell in .xls Excel files The newer features and functions that I’ll be using later in this article aren’t available in the earlier .xls format.