Learning Objectives Filter data in a table. After entering data in Excel, it is also possible to filter, or hide some parts of the data, based on user-indicated categories. When using the Filter option, no data is lost; it is just hidden from view. Method 1 Select the column or row you wish to sort. … Continue reading Filtering Data