excel help!

[Omegachi]

i have a spreadsheet with 3 columns of data. is there a way to print each row of data with a row of blank space in between each row? i could manually inserting rows in the speadsheet, but when i sort the data, excel will remove the empty rows in between... help 🙁

 

[Mo0o]

Why dont you increase the width of each column so it looks like theres another column in between each

 

[Omegachi]

can't do that because if the data in some column is bigger than the set column width, it will get cut off... unless theres a way around this.

 

[Mo0o]

Originally posted by: Omegachi
can't do that because if the data in some column is bigger than the set column width, it will get cut off... unless theres a way around this.

You can format it to be as wide as the widest data point

 

[Kelemvor]

Originally posted by: Omegachi
can't do that because if the data in some column is bigger than the set column width, it will get cut off... unless theres a way around this.

Make the column width LARGER than the data, not smaller. Then it will print with the blank space in between. And you can set the cells to "Word Wrap" if you need to.

 

[Omegachi]

Originally posted by: Mo0o

Originally posted by: Omegachi
can't do that because if the data in some column is bigger than the set column width, it will get cut off... unless theres a way around this.

You can format it to be as wide as the widest data point

that wouldn't work because what if only one cell has a super large amount of data while all the other cells has only 1 line of data.