How to Filter Every 5th Item in Excel. When manipulating large amounts of data in an Excel spreadsheet, it can be challenging or time-consuming to select specific items by hand.

Whether you're comparing a single list or several, Excel's conditional formatting can get the job done.