
- Excel - Home
- Excel - Getting Started
- Excel - Explore Window
- Excel - Backstage
- Excel - Entering Values
- Excel - Move Around
- Excel - Save Workbook
- Excel - Create Worksheet
- Excel - Copy Worksheet
- Excel - Hiding Worksheet
- Excel - Delete Worksheet
- Excel - Close Workbook
- Excel - Open Workbook
- Excel - Merge Workbooks
- Excel - File Password
- Excel - File Share
- Excel - Emoji & Symbols
- Excel - Context Help
- Excel - Insert Data
- Excel - Select Data
- Excel - Delete Data
- Excel - Move Data
- Excel - Rows & Columns
- Excel - Copy & Paste
- Excel - Find & Replace
- Excel - Spell Check
- Excel - Zoom In-Out
- Excel - Special Symbols
- Excel - Insert Comments
- Excel - Add Text Box
- Excel - Shapes
- Excel - 3D Models
- Excel - CheckBox
- Excel - Add Sketch
- Excel - Scan Documents
- Excel - Auto Fill
- Excel - SmartArt
- Excel - Insert WordArt
- Excel - Undo Changes
- Formatting Cells
- Excel - Setting Cell Type
- Excel - Move or Copy Cells
- Excel - Add Cells
- Excel - Delete Cells
- Excel - Setting Fonts
- Excel - Text Decoration
- Excel - Rotate Cells
- Excel - Setting Colors
- Excel - Text Alignments
- Excel - Merge & Wrap
- Excel - Borders and Shades
- Excel - Apply Formatting
- Formatting Worksheets
- Excel - Sheet Options
- Excel - Adjust Margins
- Excel - Page Orientation
- Excel - Header and Footer
- Excel - Insert Page Breaks
- Excel - Set Background
- Excel - Freeze Panes
- Excel - Conditional Format
- Excel - Highlight Cell Rules
- Excel - Top/Bottom Rules
- Excel - Data Bars
- Excel - Color Scales
- Excel - Icon Sets
- Excel - Clear Rules
- Excel - Manage Rules
- Working with Formula
- Excel - Formulas
- Excel - Creating Formulas
- Excel - Copying Formulas
- Excel - Formula Reference
- Excel - Relative References
- Excel - Absolute References
- Excel - Arithmetic Operators
- Excel - Parentheses
- Excel - Using Functions
- Excel - Builtin Functions
- Excel Formatting
- Excel - Formatting
- Excel - Format Painter
- Excel - Format Fonts
- Excel - Format Borders
- Excel - Format Numbers
- Excel - Format Grids
- Excel - Format Settings
- Advanced Operations
- Excel - Data Filtering
- Excel - Data Sorting
- Excel - Using Ranges
- Excel - Data Validation
- Excel - Using Styles
- Excel - Using Themes
- Excel - Using Templates
- Excel - Using Macros
- Excel - Adding Graphics
- Excel - Cross Referencing
- Excel - Printing Worksheets
- Excel - Email Workbooks
- Excel- Translate Worksheet
- Excel - Workbook Security
- Excel - Data Tables
- Excel - Pivot Tables
- Excel - Simple Charts
- Excel - Pivot Charts
- Excel - Sparklines
- Excel - Ads-ins
- Excel - Protection and Security
- Excel - Formula Auditing
- Excel - Remove Duplicates
- Excel - Services
- Excel Useful Resources
- Excel - Keyboard Shortcuts
- Excel - Quick Guide
- Excel - Functions
- Excel - Useful Resources
- Excel - Discussion
Data Filtering in Excel
Filters in MS Excel
Filtering data in MS Excel refers to displaying only the rows that meet certain conditions. (The other rows gets hidden.)
Using the store data, if you are interested in seeing data where Shoe Size is 36, then you can set filter to do this. Follow the below mentioned steps to do this.
Place a cursor on the Header Row.
Choose Data Tab » Filter to set filter.

Click the drop-down arrow in the Area Row Header and remove the check mark from Select All, which unselects everything.
Then select the check mark for Size 36 which will filter the data and displays data of Shoe Size 36.
Some of the row numbers are missing; these rows contain the filtered (hidden) data.
There is drop-down arrow in the Area column now shows a different graphic an icon that indicates the column is filtered.

Using Multiple Filters
You can filter the records by multiple conditions i.e. by multiple column values. Suppose after size 36 is filtered, you need to have the filter where color is equal to Coffee. After setting filter for Shoe Size, choose Color column and then set filter for color.
