Feature Summary

The filter feature is used to quickly display records that meet specific criteria in large datasets and hide rows that do not, making data viewing and analysis easier.

Feature Description

Feature Dimension Description
Membership Restrictions No membership restrictions
Version Restrictions No version restrictions

Steps

Enable Filter from the Ribbon

Feature Entry
"Data" tab → "Filter" dropdown menu → "Filter" button

  1. Select any cell within the data range
  2. Click the "Filter" button in the Data tab
  3. Dropdown arrows will appear in the header row

image

Enable Filter from the Right-Click Menu

Feature Entry
Right-click any cell → "Filter" dropdown menu → "Filter" button

  1. Select any cell within the data range
  2. Right-click the selected cell and choose the Filter dropdown menu
  3. Click the "Filter" option
  4. Dropdown arrows will appear in the header row

image

Enable Advanced Filter from the Ribbon

Feature Entry
"Data" tab → "Filter" dropdown menu → "Advanced Filter" button

  1. Select any cell within the data range
  2. Click the "Advanced Filter" button in the Data tab
  3. Set filter criteria in the pop-up dialog box
  4. Click OK

image

Enable Advanced Filter from the Right-Click Menu

Feature Entry
Right-click any cell → "Filter" dropdown menu → "Advanced Filter" button

  1. Select any cell within the data range
  2. Right-click the selected cell and choose the Advanced Filter dropdown menu
  3. Click the "Advanced Filter" option
  4. Set filter criteria in the pop-up dialog box
  5. Click OK

image

Enable Filter from the Home Tab

Feature Entry
"Home" tab → "Data Processing" dropdown menu → "Filter" dropdown menu → "Filter" button

  1. Select any cell within the data range
  2. Click the Data Processing dropdown menu in the Home tab
  3. Click the Filter dropdown menu
  4. Click the "Filter" button
  5. Dropdown arrows will appear in the header row

image

Enable Advanced Filter from the Home Tab

Feature Entry
"Home" tab → "Data Processing" dropdown menu → "Filter" dropdown menu → "Advanced Filter" button

  1. Select any cell within the data range
  2. Click the Data Processing dropdown menu in the Home tab
  3. Click the Filter dropdown menu
  4. Click the "Advanced Filter" button
  5. Set filter criteria in the pop-up dialog box
  6. Click OK

image

FAQ

Q1: How to copy visible cells after filtering?

  • Solution: When copying filtered results, only visible cells are copied; hidden rows will not be copied.

Q2: How to cancel filtering?

  • Solution: Click the "Filter" button again or click the "Clear" button to cancel filtering.

Notes

  • Filtering does not delete data; it only hides rows that do not meet the criteria
  • Filter criteria can be set for multiple columns simultaneously
  • Copying while in a filtered state only copies visible data