Excel’s filtering feature is powerful and the new table-filtering feature offers even more. However, there’s one thing neither can do: neither can filter a data set by odd or even rows. Fortunately, it’s easy to do. Simply add an extra column to the data set as follows and filter by the results:
- In an adjacent column, use the =ISEVEN() or =ISODD() function, combined with a ROW() function that references any cell in that row.
- Double-click the cell’s fill handle to copy the formula to the remaining range.
Automatically sign up for our Microsoft Office newsletter!
Next, enable a simple filter by selecting any cell in the data range and clicking Filter in the Sort & Filter group on the Data tab.
Click the new column’s filter dropdown and choose False or True. False will display odd rows; True will display even rows.
