Excel Five Great Tips for Filtering Data

Posted on: 12/06/2021

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

Filter by selected cells value
Copy and paste filtered data
Delete filtered data
Auto-calculate filtered data
Search for filtered data

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

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.

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.

Recent Excel articles

Excel Conditional Formatting with the TODAY function | Duplicate Rule

The TODAY function is one of my favorite Date & Time functions in Excel. It returns the current date and will automatically update. We will use the TODAY function with Conditional Formatting and create three rules on a date field.

Excel Accounts Payable / Accounts Receivable Exercise - Watch Chris Work

Accountants use Excel all the time. In this video, which is great for Accounting students, we look at the Accounts Receivable (AR) or Accounts Payable (AP) exercise.

Excel Recommend PivotTables - Improved Experience

Recommended PivotTables in Excel is getting a great update. To use Recommended PivotTables, click the Insert Tab, and click Recommended PivotTables.

Excel PivotTable - Calculate the number of days of each week for every month of the year

If you want to calculate how many days are in each month for a year, it is easy to do with a PivotTable in Excel. I want to know how Sundays through Saturdays there are for each month of the year.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with other 750 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 10 million viewers have appreciated.