| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Selecting alternate rows
I have a large file (Excel XP) with about 300+names and related details. I
need to break it into 2 files but I need to select alternate rows for each file. It may come out to every 3rd row to work into 3 files. Is there a quick way to do this rather than tediously select each alternate row, copy to the new file and delete from the old file? Many thanks for your help. Norm. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I delete blank rows from excel without selecting them? | Excel Worksheet Functions | |||
| Summing Alternate Rows | Excel Discussion (Misc queries) | |||
| HOW CAN I AUTOMATICALLY INSERT ALTERNATE BLANK ROWS IN A LIST? | Excel Discussion (Misc queries) | |||
| Use of Exact(or other) function for alternate rows? | Excel Worksheet Functions | |||
| Identifying exact values in alternate rows | Excel Worksheet Functions | |||
Threaded Mode
