Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying a row
How do I copy a single row to every alternate row to the end of the
spreadsheet. Spreadsheet can vary in size. i.e. Can be 100 rows - 500 rows |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
copying a row
Say your "single" row is Row1, from A1 to IV1.
You can enter this formula *anywhere*, but for the sake of this demo, say you enter it in A2: =INDEX($1:$1,ROWS($1:2)/2) NOW, select A2 *and* A3, with A3 being empty. Click on the fill handle of that 2 cell selection and drag down as needed. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Excel Greenie" wrote in message ... How do I copy a single row to every alternate row to the end of the spreadsheet. Spreadsheet can vary in size. i.e. Can be 100 rows - 500 rows |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying worksheets | Excel Worksheet Functions | |||
Copying Formats | Excel Discussion (Misc queries) | |||
copying | Excel Discussion (Misc queries) | |||
Copying | Excel Discussion (Misc queries) | |||
copying function value | Excel Discussion (Misc queries) |