Select one of the colored cells in the Excel spreadsheet. From there, click on the Data tab above the Ribbon area. Via the Sort & Filter section, please click on Sort.

Click Sort & Filter > Custom Sort and the Sort dialog box opens. 3. If you have headers, be sure to check the box that says: My data has headers. 4.

How to filter data in Excel for one column 1. Select the column by clicking the corresponding letter at the top. 2. Click on "Data" along the top toolbar. 3. Click on "Filter" in the top toolbar.