How to Space Equally in Excel. Rows in Microsoft Excel change their height to fit their contents. For example, if each cell in the row contains a single word, the row will keep its default height ...

In such cases, you can add space by indenting the data in one of the columns. You can also increase the space between columns in your Excel chart using the Data Series formatting tool.

You can even insert blank rows in between each row you've selected, but this involves a little workaround. So whether you're on PC or Mac, here's how to add multiple rows in Excel.

Excel’s BYCOL() and BYROW() functions evaluate data across columns and rows, returning an array result set allowing you to bypass a lot of work.