Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formula for Duplicating Rows | Excel Discussion (Misc queries) | |||
Duplicating rows help needed | Excel Worksheet Functions | |||
Duplicating Rows Based on Cell Value | Excel Discussion (Misc queries) | |||
How do I prevent rows from duplicating when sending a worksheet? | Excel Worksheet Functions | |||
Formula for Duplicating Rows!! | Excel Discussion (Misc queries) |