#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 45
Default duplicating rows

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default duplicating rows

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"

Patty wrote:

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula for Duplicating Rows J4mesD4wson Excel Discussion (Misc queries) 3 April 1st 09 06:07 PM
Duplicating rows help needed ArthurN Excel Worksheet Functions 3 October 28th 07 09:41 PM
Duplicating Rows Based on Cell Value [email protected] Excel Discussion (Misc queries) 6 September 19th 06 11:35 PM
How do I prevent rows from duplicating when sending a worksheet? CIA @ honeywell Excel Worksheet Functions 0 September 14th 06 02:40 AM
Formula for Duplicating Rows!! GOL Excel Discussion (Misc queries) 2 May 22nd 06 08:54 PM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"