Mar 28 2019 10:16 AM
I have an excel spreadsheet with text on 20 lines.
I now need to add a line in between all 20 lines.
Is there an easy way to do this?
Mar 28 2019 11:15 AM
@iris001 I'm assuming that you need to enter a blank row between each row of data. You can add a helper column that contains the numbers 1-20 in the rows 2 to 21. Copy this same data and paste it into the rows 22 to 41. Sort the data on this column in the ascending to descending order and you should have a blank row for every row of text.