Click the small arrow at the bottom-right corner of the "Page Setup" panel in the toolbar. Click the Page Setup link under Settings.
Here we discuss how to filter a column in Excel along with practical examples and a downloadable excel template.How to print excel sheet with lines. This has been a guide to Filter Column in Excel. It will take a lot more time to get applied, and sometimes the file also gets crashed. Avoid or be cautious while using a filter for huge sets of data (maybe for 50000 or more).
By doing this, data will be frozen from the middle portion of the sheet.
This drop-down is those things by which we can filter the data as per our need. Once we click on Filters, we can see the filters will be applied in the selected row, as shown in the below screenshot.