asked on Why in Excel 2010 the filter doesnt work if empty rows
For some strange reason we have noticed that if we click on Filter and the first line (under the line we click filter) has no data, filer will not work correctly. Sometime we have to place a dot.
What is the cause and how can we get filter working correctly?
What is the cause and how can we get filter working correctly?
Microsoft Excel
Last Comment
jana
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Understood.
ASKER
Thanx
Is it possible to just click the row to filter and have everything under it included within filter? (without the need of select all the area)
We ask this because most of the times, the select area has a lot of columns which obviously are not displayed on screen unless scrolling to them. Selecting is a somewhat tedious.