Jump to content

Craft custom filters


Recommended Posts

Craft custom filters

Have you ever needed to locate all the records in an Excel 2000 worksheet that contained a particular letter or string of letters? To do so, you can use Excel's AutoFilter feature to create a custom filter. You can even use the custom filter to locate all the records that don't contain a particular letter or string. Here's how it works.

1. Enter column labels in the first row of your data range. Although AutoFilter will work if your data doesn't contain column labels, it's good practice to enter such labels.

2. Go to Data | Filter | AutoFilter, click the drop-down arrow for the label of the column whose contents you want to change, and choose Custom.

3. On the Custom AutoFilter dialog box, click the drop-down arrow for the top-left field, and choose either Contains or Does Not Contain from the list.

4. Press [Tab] to move to the next field, and enter the character or string of characters for which you want to search.

When you click OK, Excel uses this custom filter to display only the records that contain (or don't contain) the character or characters you entered.

To restore the rest of the records, click the drop-down arrow for the column in question and choose All.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...