logo ASAP Utilities
HomeExtra features for ExcelColumns & RowsSelect, Hide, or Delete Rows or Columns Based on Custom Criteria...

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu
Trustpilot

Select, Hide, or Delete Rows or Columns Based on Custom Criteria...

ASAP Utilities  › Columns & Rows  ›  1. Select, Hide, or Delete Rows or Columns Based on Custom Criteria...

This tool provides a fast and flexible way to select, hide, or delete entire rows or columns based on specific criteria, making it a powerful alternative or complement to Excel's AutoFilter. You can apply the following criteria to select, hide, or remove entire rows or columns:
  • between
  • not between
  • equal to
  • not equal to
  • greater than
  • less than
  • greater than or equal to
  • less than or equal to
  • like (text, with use of wildcard characters)
  • not like (text, with use of wildcard characters)
  • duplicate values (you can choose to keep the first value)
  • unique values
  • odd rows
  • even rows
  • every n'th row number
  • odd columns
  • even columns
  • every n'th column number
  • empty cells
  • completely empty rows
  • completely empty columns Additional options:
  • You can choose to make the search case-sensitive for text, duplicate, and unique value criteria.
  • Hidden cells are ignored, except when searching for duplicate or unique values.

    Screenshots

    Example screenshot: 1 Conditional row and column select hide or delete
    1 Conditional row and column select hide or delete
    ASAP Utilities makes YOU rock in Excel!

    Practical tricks on how this can help you

    Practical 'real world' examples on our blog that show you how this tool can help you in Excel. Enjoy!

    Starting this tool


    Columns & Rows  ›  1 Select, Hide, or Delete Rows or Columns Based on Custom Criteria...
    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
    Trustpilot
    Download  



    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


    🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
    For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.