Excel Five Great Tips for Filtering Data

Posted on:  12/06/2021
Excel Five Great Tips for Filtering Data

Filtering data is one of the most popular Excel features. Here are five great filtering tips for Excel.

  1. Filter by selected cells value
  2. Copy and paste filtered data
  3. Delete filtered data
  4. Auto-calculate filtered data
  5. Search for filtered data
Excel - Filter data tips

Excel - Filter data tips

Tip #1  - Filter by Selected Cell Value

Select the cell you want to filter by, right-click and select Filter by Selected Cell Value.

Recent Teams articles

YouTube video

Other Excel articles

Tip #2 - Copy and Paste Filtered Data

After filtering data, you can copy and paste just the filtered data. The hidden rows do not get included in the copy/paste.

Copy - Paste Filtered data

Copy - Paste Filtered data

Tip #3  - Delete filtered data

To delete a set of data, filter the data, select it, and delete it. Only the filtered or visible rows get deleted.

Tip #4 - AutoCalculate Filtered Data

When data is filtered, select a range of numbers, and in the bottom right of the screen, the status bar calculations are correct for what is visible.

Autocalculate works with Filtered Data in Excel

Autocalculate filtered data

Tip #5 - Search filtered data

Use the Search feature to quickly find account numbers, names, and other text fields. You can do partical searches in the search box.

 

Search box in filters

Search box in filters

Recent Excel articles

Excel Conditional Formatting - Getting started with five examples

Excel Conditional Formatting - Getting started with five examples

Excel Five Great Tips for Filtering Data

Excel Five Great Tips for Filtering Data

Excel - Create a custom list to sort data

Excel - Create a custom list to sort data

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Chris Menard

Chris Menard is a Senior Training Specialist at SurePoint Technologies. Chris is certified in Excel, Word, PowerPoint, and Outlook. Menard has a YouTube channel with other 600 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 7 million viewers have very appreciated. Because of Chris's certification and expertise with Microsoft, Chris is a proud member of Microsoft's Creator Team. Being a member of Microsoft's Creator Teams means many of his videos are available on Microsoft 365 YouTube channel and Microsoft support websites.

Categories