Transcript of the video:

L.C. has 4000 rows of data.

He needs insert one blank row after every two data rows.

This is going to use Go To Special. Type some text here, a number here.

Equal sign and point to the cell two cells above. Double click the fill handle to shoot that down.

That puts text on every other row. Control G for Go To.

Click Special. Choose Formulas. Unselect Numbers, Logicals, and Errors.

That leaves only the text selected, which gives us every other row.

Home, Insert, Insert Sheet Rows. Let the spinning circle spin for a good 20 - 30 seconds. Don't worry, it's inserting 2000 rows.

And you're done. Clear Column F, press the Delete key.

Great question from LC! Thanks for watching.

Click Subscribe.

He needs insert one blank row after every two data rows.

This is going to use Go To Special. Type some text here, a number here.

Equal sign and point to the cell two cells above. Double click the fill handle to shoot that down.

That puts text on every other row. Control G for Go To.

Click Special. Choose Formulas. Unselect Numbers, Logicals, and Errors.

That leaves only the text selected, which gives us every other row.

Home, Insert, Insert Sheet Rows. Let the spinning circle spin for a good 20 - 30 seconds. Don't worry, it's inserting 2000 rows.

And you're done. Clear Column F, press the Delete key.

Great question from LC! Thanks for watching.

Click Subscribe.