Office packs numerous useful tools, and Excel is among the most prevalent among them. However, there are instances when the spreadsheets do not filter properly. In case the user is facing the issue as well, then here is what he can do to fix it. So, here are the steps to fix Excel table filtering.
Choose the Entire Column to Apply the Filter
In case the user wishes to choose the entire column to apply the filter, then they can pursue the mentioned instructions.
You should choose the table’s entire spreadsheet column by selecting the letter of the column.
Go to the Data button and click on it.
After that, select the Filter option to save the filter to the entire column.
You have to select the cell filter arrow icon to launch the filtering buttons displayed straightly under.
Now, unselect the Blanks boxes to leave out the blank cells.
Source :
Excel Spreadsheet Filtering Issues
norton.com/setup !
www.norton.com/setup