Forum Discussion
Excel Sort Based on Cell Contents
Years ago I used to be able to sort my spreadsheet based on a value. Somehow I got to the point where it would ask me how I wanted to sort and one of the options was Contents. You could enter a value...
Click in your data.
On the Data tab of the ribbon, in the Sort & Filter group. click to highlight the Filter button.
This will add filter dropdown arrows to the column headers in the first row of the data,
Clicking a dropdown arrow will display a menu with options to filter and sort the data: