- Select the column with the Mod() functions. In this case, that's G1:G11.
- Choose Filter from the Data menu.
- Select AutoFilter.
- Using the filter drop-down arrow, choose 0. Excel will display only the rows that contain a 0 in column G.
- Select the rows displayed by the filter; in this case, that's rows 4, 7, and 10.
- Choose Delete Row from the Edit menu to delete the selected rows.
- Remove the filter by selecting (All) from its drop-down list.
- Uncheck AutoFilter from the Filter menu (the Data menu).
- Delete the sequential number list in column F and the Mod() functions in column G. (Or leave them, if you need to repeat this task frequently.)
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.