duplicating rows

P

Patty

How do I duplicate rows in Excel such that the row is inserted directly below
the original version? I have a worksheet with 100 rows of data that I want
to duplicate such that rows 1 and 2 are identical.
 
B

Bob I

In a spare column, number the rows, then all the current rows and copy
paste them below the first set and then sort on the "numbered column"
 

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 non adjacent rows 3
Bug in Advanced filter 1
Formula for Duplicating Rows 3
Locating row with no duplicate matching amount 1
finding unique values 2
how do i combine excel worksheets 1
Delete duplicate and original row 3
ROWS works but I want one less row result 3

Top