Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Maybe add an extra column with two values (0,1) for odd and even rows by
entering 0,1,0,1 down the column. Extend the selection by selecting the first few values and double-clicking the fill handle (in the bottom right corner of the selection). Now you can use DataFilterAutofilter to select 0,1 to show alternate rows. "mmcclain" wrote: In a large file, is it possible to select all even or odd rows quickly? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel should let you select 2 rows, right click, and SWAP them | Excel Worksheet Functions | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
How to select and deselect rows in Excel | Excel Discussion (Misc queries) | |||
Is there a way to randomly select rows in Excel? | Excel Discussion (Misc queries) | |||
How do I select multiple rows randomly in MS Excel? | Excel Discussion (Misc queries) |