Excel - how to insert multiple rows at one time! 2

[wec43wec]

I have a spreadsheet with data in each row (as an example) from row 1 through row 500 and I want to add a blank row between each of the 500 existing rows.

Is there an easy way to complete this task without having to use VBA?

Thanks

 

[1726]

Why?

Adding blank rows between data breaks all rules of table design.

If you need space when it prints consider changing the row height.

 

[Salut39]

Hi,

The way you can do it is add another column put the numbers next to your 500 row, (1,2,3...500), then copy (1,2,3...500) to further 500 lines and then sort by new newly created column.

Yuri

 

[wec43wec]

Yuri - your solution seems like it may what, but I am not understanding your second sentence of how to apply the new column count to 500.

Please advise - thanks

 

[wec43wec]

Yuri - excellent !!!!!!!

I got it - thanks !!!!

 

[SkipVought]

What are LIST & TABLE PRINCIPLES for Spreadsheet Users faq68-5184

Empty rows in a table is a REALLY bad practice!

 

[SkipVought]

...of course, if you simply want to make your table look nice and don't care about imparing data analysis functionality and data manipulation features, have at it.

But if you do intend to analyze and manipulate your data, you've added weights to your running shoes!

 

[wec43wec]

Skip, just for the record, I agree with everything you've said, in fact, you have mentioned this to me before.

However, I was helping someone else and I was not going to change their data.

Thanks again !

 

[SkipVought]

...and I was not going to [highlight #FCE94F]change[/highlight] their data."

But [highlight #FCE94F]THAT[/highlight] is exactly what you did!