Excel Tip #10 - Change a Single Spaced Sheet into a Double Spaced Spreadsheet
Nov 4, 2013 - Posted by Kevin Hsu
Suppose your end goal is illustrated below (ignore column F for now). You want each row of data to be separated by a blank space. This could be because you want your data to look cleaner or just easier to read.
You started with the below data set. One way of spacing this out is by adding numbers to the right or left side of the data set. In the below spreadsheet picture, we've labeled each row of data from one to eight. Then just below it repeat the same numbers.
After you've finished labeling the rows as such, find the filter button which is under 'Sort & Filter'. You can then either sort from smallest to largest or largest to smallest. Depending on how you sort, your list could be flipped or remain the same. Pick smallest to largest and if that is how you labeled it, then it will look as if you just add extra rows to your original data set.