Software

A clever trick for filtering odd and even rows in Excel

If you want to see only odd or even rows in an Excel worksheet, use this quick filtering trick.

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:

  1. In an adjacent column, use the =ISEVEN() or =ISODD() function, combined with a ROW() function that references any cell in that row.
  2. Double-click the cell's fill handle to copy the formula to the remaining range.

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.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

Editor's Picks