Link to home
Start Free TrialLog in
Avatar of jana
janaFlag for United States of America

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?
SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Ok, selecting the are worked (we selected or highlighted the entire are we want filter).

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.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jana

ASKER

Understood.
Avatar of jana

ASKER

Thanx