inserting rows in entire sheet
 

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?

inserting rows in entire sheet
 

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


"add" wrote in message
...
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?