Filter

[neeraj2050]

Greetings!!


In excel, there is a column consisting of numerical. While filtering, I have to select those cells that constitute of “0” only. But as soon as I press “0” into the bar all those values having “0” into it appears i.e 100,110,etc rather than only those cells which constitutes only “0”


Thanks in advance!!

 

[vletm]

neeraj2050
You could use 'Equals' ... and write 0

or
deselect (Select All) and select just 0

 

[neeraj2050]

Dear Sir,

I have been using MS Office 2010. Kindly suggest

 

[vletm]

neeraj2050 - hmmm?
I don't use same version ...
How many solutions do You need?

 

[Pavan Kumar Sistla]

Hi,

You need to use Alt+DownArrow key combination after applying filter, so that you will get dropdown. From that you need to click on Number Filters and in equals section, enter 0 so that only the records with 0 are selected.

Thank You and Regards,
Pavan.