inserting rows in entire sheet

A

add

If you create an excel worksheet with data in each row, (say 100 rows), and
later you decide you want to insert a blank row between each row of data, is
there a tool, or procedure that will do this quickly without having to go to
each row and insert a blank?
 
B

Bernie Deitrick

add,

Insert a new blank column A. Fill it with the numbers 1 to 100 (or however many rows you have).
Copy those numbers, use end-down down to get below the numbers, paste the numbers, then sort the
entire table based on column A ascending. It will intersperse blank rowns in your data.

Or, if you are just going for look, change the row heights....

HTH,
Bernie
MS Excel MVP
 
Top