After that press “ALT + ENTER” option for typing in the new line of the cell. In such cases, the Wrap Text function also works great in formatting the cells correctly. Another reason for your Excel filter not working is because of the merged cells. So unmerge if you have any merged cells in the spreadsheet.
You could be thinking “Why isn’t my filter returning the correct data?”
If you’re using the Number Filter or Date Filter, Equals filter and Excel isn’t returning the correct data, check the formats on your data are the same.
One very common problem with the Excel filter function is that it won’t work with the blank rows. Excel Filter doesn’t count the cells with the first blank spaces. To fix this, you need to choose the range right before using the filter function.
What to do when Excel is not showing the right data?
While using the Equals filter, Number Filter, or Date Filter, if your Excel is not showing the right data then check whether the format of your data is the same or not. Suppose, if you are having 2 cells and in each cell, you have entered 1000 as data.
Why is my Excel so slow?
If your answer is yes, then it is also one of the reasons behind Excel working slow. Many users have a bad habit of storing a lot of data in one sheet. If you are using volatile functions along with too big spreadsheets, then it will slow down your Excel performance.
Why does excel lag?
Another reason for Excel lagging is Unresolved Formulas. So, if you have a sheet in your excel whose cell has a value> 0, then it means a cell having unresolved formulas. And that can also be the reason why you have encountered this problem .
But using hardware acceleration sometimes may lead to a lag in Excel files after inputting data. In such situations, you can disable hardware acceleration to prevent lagging. Here is how to disable hardware acceleration in Excel:.
Why does my Surface Book lag when I open Excel?
It seems that the lag only happens in Excel but it does not affect any other application. I suggest you temporary close all 3rd party applications/processes, and open Excel in safe mode to disabled add-ins on the Surface Book to ensure the issue is not caused by the compatibility problem with 3rd party apps.