Toggle Help to get info on how to use Multi-column sort, filter, copy, range operations and many more ...
- First make sure you installed TableTools2 and restarted Firefox.
- Sort, Multi-column sort, Filtering/copying, Summary and all other functionalities can be access through both context menu (right click menu) and keyboard shortcuts (one can go to Options to change shortcuts)
- All-column-search: Press Ctrl+Shift and Right Mouse Click to bring up the "search filter", type ":ALL:keyword" to search for keyword in ALL table columns, not just the current column. The keyword-matching cells will be highlighted (one highlighted cell per row). Highlight can be removed through context menu or by filtering again
- Inverted search: From the "search filter", use ":INV:keyword"; for "select filter", press 'shift' key while clicking on an option
- Inverted all-column search: Use ":INVALL:keyword" in the "search filter"
- Use range operations in "search filter": "<=5 & >3" gives you any # that's over 3 and less or equal to 5; ">= 01.01.2009 | < 01.01.2007" in a M/D/Y date column gives you dates prior to 2007 or in or after 2009. Note:When using range operators on numbers or dates, space character (' ') doesn't matter - "<=5 & >3" is the same as "<=5&>3". But when using it on free strings, ' ' is taken as part of the string IF the ' ' is right next to the string, which means "<cd & >ab" would search for strings bigger than 'ab' but smaller than 'cd ' (not 'cd').
- Also note that ':INV:' and other operators work with range operations too, meaning ':INV:ab|cd' would find all cells whose content is NOT 'ab' or 'cd'.
- Don't stop at the currency/number/date columns, try the range operators on IP addresses column and the "Image & Form" columns too! The range operations work in practially any column!
- BTW range operations do not always make sense when combined with all-column-search, in such case it's best to first hide the columns where range operations do not fit, and after search, unhide them again to see all data.
