• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Filter on Blanks in table in Excel 2010 no longer works

P

Pengorn

New Member
In previous versions of Excel, in a table (or a set of data with a filter) I would press:

windows key (or right click)

e (filter...)

v (filter by selected cell's value).


I would do this on a blank cell and it would filter on all blank cells.


In Excel 2010, when you do this, it filters the table, but no cells are visible. To filter onto blank cells, you have to click the filter column header, deselect all, then select blanks. Which is a lot more keystrokes.


Is anyone else getting this problem (hassle) in 2010?
 
Edit: I tried to do this in Excel 2007 and it worked great. When I right clicked a cell, then Filter > FIlter by Selected Cell's Value, no rows are shown although there were rows with blanks value. Is it perhaps a bug in Excel, then?
 
You must log in or register to reply here.
Back
Top