I don't know of any native way to add white space between rows, but this simple macro does the job. It prompts the user to input a value for the extra space (which is created by increasing the row height of each row by a certain amount greater than the 'auotfitted' height):
Code:
#Sub RowHeight()
Dim rngRows, rngCell As Range
Dim h, n As Single
n = InputBox("Space to add:", "Add space between rows", 15)
Set rngRows = Range(Range("B2"), Range("B2").End(xlDown))
rngRows.Rows.AutoFit
For Each rngCell In rngRows
h = rngCell.Height
rngCell.RowHeight = h + n
Next
End Sub#
Edit Mod : related to
https://www.msofficeforums.com/excel...text-cell.html