Close

Not a member yet? Register now and get started.

lock and key

Sign in to your account.

Account Login

Forgot your password?

SOLVED: How To Filter or Select or Remove Rows in An Excel Table Based on A Cells Contents

If you have an Excel table with a number of ROWS you want to have selected and removed based on the contents of a cell, you can use the SORT & FILTER editor.  It is very easy to use.

  1. Simply click on the column you want to evaluateHow-to-Filter-Select-Remove-Rows-in-an-Excel-Table-Based-on-Cell-Contents
  2. On the HOME tab click  SORT & FILTER then click the FILTER from the drop down
  3. Click drop down box at the top of the column you selected in step 1
  4. Click TEXT FILTERS
  5. Click BEGINS WITH or any other rule that is appropriate for you
  6. Add any other rules you want to the CUSTOM AUTOFILTER box
  7. Have a nice day

To make this easier to understand we have a 90 second video showing the steps:

Share This With Your Friends Now:
Facebooktwittergoogle_plusredditpinterestlinkedin

Leave a Reply

Please confirm you are a person and not a 'bot' by answering this simple question: Time limit is exhausted. Please reload CAPTCHA.