logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Wednesday December 17th, 2025

Tip of the Day | Wednesday December 17th, 2025

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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

    Starting this tool


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

    Choose your language preference below

    English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

    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.