inserting rows in entire sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Inserting blank rows 3
INSERTING ROWS 5
Excel Help to copy information from one row at a time to another sheet 1
How do I insert a row between every line in my spreadsheet? 3
Inserting Blank rows between items 6
How do i insert blank rows between data that is thousands of rows 5
Excel-Adding rows to master sheet that will be inserted on following worksheets 1
Inserting rows using a list of numbers 3

Back
Top