Call us on 01223 214177 or email us
Do you know what you don't know? I don't! Even though I've been using Excel version 2010 for ages and have done various "What's new in Office 2010" rollouts I was still using old habits when it came to filtering data in a list. OK, I use the new date, text and number filters and the PivotTables slicer (I don't think I ever wrote a tip about these, so watch this space) but it wasn't until one of my course participants pointed out the Search box that I realised I missed a trick.
Here's how:
Thanks, Stuart! This sure beats CTRL+F and right-clicking the cell to filter. I now not only use this fast filtering in Excel lists, but also in PivotTables!
I’m committed to sharing the best of what I know with others so please don’t keep me a secret. If you enjoyed today’s tip, please forward it to anyone you feel may benefit. Alternatively, feel free to reprint it (with full copyright and subscription information) in your newsletters and message boards.