Excel: insert a row between each row
Solved
El-sol
-
Loui -
Loui -
Hello,
I have an Excel document with over 300 rows of information. How can I add a line between each one at once?
Thank you
Configuration: Windows 2003 / Internet Explorer 7.0
I have an Excel document with over 300 rows of information. How can I add a line between each one at once?
Thank you
Configuration: Windows 2003 / Internet Explorer 7.0
9 réponses
Another simpler trick is to add a column that numbers your rows (e.g., from 1 to 300). Then, you number the 300 empty rows just below, again in the same column (again from 1 to 300).
All you have left to do is sort the data based on the column with the numbers, and then delete that column.
It's a quick fix, but it works.
All you have left to do is sort the data based on the column with the numbers, and then delete that column.
It's a quick fix, but it works.
toufik
thank you very very very very very very very very.......................................
kamal
Thank you for the tip. It's effective.
