Prev: Enabling Spell Check in Protected Worksheet
Next: what should happen after the coma (,) feature is applied in excel
From: Patty on 10 May 2010 12:12 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.
From: Bob I on 10 May 2010 14:26
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. |