• ASAP Utilities
  • Download
  • Contact Us
ASAP Utilities Icon

ASAP Utilities Blog

“Do more and save time in Excel with these popular tools”

  • Home
  • Practical Tricks to Save Hours in Excel
  • Download
ASAP Utilities How to how to with ASAP Utilities

User question: How to delete cells based on content

by Bastien Nov 18, 2011 0 Comment

"Hi!
I couldn't find the following function in ASAP Utilities:
Delete cells based on content. Ex.: I would like to delete all cells (content) which is less than 3, greater than 100…. Would be nice when working with statistics."

Well, you can already do this in ASAP Utilities, but with an additional step.
First you can select those cells with the following tool, and then just hit the DEL key:
Select » Select cells based on content, formatting and more...

Select cells based on content, formatting and more...

Related Posts

Update Excel
ASAP Utilities General
The importance of Microsoft Office Update | Fix random crashes and performance issues
ASAP Utilities how to with ASAP Utilities save 5 more minutes a day
Tip: Easily move and resize your range selection(s) in Excel (Video Tutorial)
ASAP Utilities General
Small update to website and blog: responsive/mobile friendly
Export selection or active sheet as new file...
ASAP Utilities how to with ASAP Utilities save 5 more minutes a day
Tip: Quickly save just your selection or sheet as a new file
Quickly Clean Up Data and Formatting in Excel
ASAP Utilities how to with ASAP Utilities save 5 more minutes a day
Tip: Quickly clean up your data in Excel

Bastien

Website: https://www.asap-utilities.com

ASAP Utilities Reviews

Trustpilot

Recent posts

  • The importance of Microsoft Office Update | Fix random crashes and performance issues
  • Tip: Easily move and resize your range selection(s) in Excel (Video Tutorial)
  • Small update to website and blog: responsive/mobile friendly
  • Tip: Quickly save just your selection or sheet as a new file
  • Tip: Quickly clean up your data in Excel

Categories

  • ASAP Utilities
  • Functions
  • General
  • How to
  • how to with ASAP Utilities
  • save 5 more minutes a day

Excel blogs

  • Headlines from the best Excel weblogs

Excel sites

  • AJP Excel Information
  • Application Professionals
  • AutomateExcel
  • Contextures
  • David McRitchie
  • ExcelUser.com
  • JKP Ads Excel articles
  • Jon Peltier (charts)
  • Office Automation
  • OzGrid
  • Vertex42

Excel Discussions

  • Microsoft Office Discussion Groups
  • MrExcel forum
Copyright © 1999-2021 | ASAP Utilities for Excel | Powered by WordPress | ConsultStreet theme by ThemeArile