|
|||
![]() ![]() | |||
ASAP Utilities, description of our Excel tools![]() Select » 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 » Select » Conditional row and column select, hide or delete...« Return to the list of “Select” 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 | |||
Home
Sitemap
Search
List of all utilities
Printer friendly page
^ Back to Top
© 1999-2018 - Bastien Mensink - ASAP Utilities - A Must in Every Office BV - The Netherlands
Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
![]() ![]() |