Need Help? Chat with us

Working with filtered Data?

How to ignore hidden values of a filtered data while computing Sum, Average in Excel in Hindi



Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

For quick filtering, do this:






1. Click the arrow Filter drop-down arrow in the table header of the column you want to filter.

2. In the list of text or numbers, uncheck the (Select All) box at the top of the list, and then check the boxes of the items you want to show in your table.

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook