How to insert rows that copy cell content of the row above

  • Thread starter Rocket Scientist
  • Start date
R

Rocket Scientist

I would like to insert ten new rows in an Excel 2003 spreadsheet and have
Excel automatically copy the cell contents of the first row above the
insertion point. This will prevent the need to manually copy the first row
that has the data in the cells and paste this into the newly inserted ten
rows.

Does Excel offer this capability?
 

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

Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
How do I insert a row or rows between each row of text and copy the row above? 0
Automatically Increment numerically ordered rows 3
Need excel copy a row and automatically insert new rows based on a cell contents 0
how to add a combolist drop down to each row 2
Insert Rows Below 6

Top