ASAP Utilities, description of our Excel toolsEnglish (us) / Nederlands / Deutsch / Español / Français / Português do Brasil / Italiano / Русский / 中文(简体) / 日本語
Columns & Rows » Conditional row and column select, hide or delete...This utility allows you to select, hide or remove rows or columns based on a certain condition.
You can use the following criteria to select, hide of remove the entire rows or columns:
With the criteria for text and duplicate or unique values you can choose if you want the utility to be case sensitive.
When looking for duplicates the program also searches in hidden cells in your selection, with the other search options hidden cells are skipped.
Some people use this utility as an alternative for or addition to Excel's AutoFilter.
Practical tricks on how this can help youPractical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!
Starting this utilityIn the Excel menu choose: ASAP Utilities » Columns & Rows » Conditional row and column select, hide or delete...
« Return to the list of “Columns & Rows” tools.
Download ASAP Utilities
Additional keywords for this tool:
Delete every second row, Double, Based on criteria, Duplicate lines,highlight , filter, select rows or column in intervals, duplication, the same value, highlight, line, select within, choose, pick, dedupe, deduplicate, undouble, blanks, delete blank rows, blank lines, only
Follow ASAP Utilities on Facebook
List of all utilities
Printer friendly page
^ Back to Top