Solved Help me Duplicate Rows In Excel

October 25, 2017 at 07:24:14
Specs: Windows 7
I have an excel sheet that i dumped a report into and it has 300 different lines. I want to duplicate each line one after another, how can i do this without copy and inserting each individual line?

See More: Help me Duplicate Rows In Excel

Reply ↓  Report •

#1
October 25, 2017 at 07:29:34
✔ Best Answer
Try this:

Select ALL 300 lines
Select Copy

Goto line 301
Select Paste

Select All 600 lines
Select Sort

Should give you want your looking for.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
October 25, 2017 at 08:55:26
This is just a posting tip...

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "Help Me With Excel" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Please keep this in mind for future questions. Thanks!

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question