How to Sort and Filter Data in Excel

Microsoft Excel can perform basic database-style tasks such as sorting and filtering data. These tools allow you to reorganize rows of information or temporarily display only the data that meets specific conditions. In this tutorial you will learn how to sort data alphabetically and use filters to display selected rows within a worksheet.

Preparing Data for Sorting and Filtering

Sorting and filtering works best when your data follows a simple structure:

  • one row of headings at the top

  • each column contains one type of information

  • each row represents one record

For example, a worksheet might include headings such as:

  • client number

  • first name

  • last name

  • occupation

  • gender

The headings describe the values stored in the rows beneath them.

Turning On Filters

To begin using sorting and filtering tools:

  1. Select the row that contains the column headings

  2. Go to the Home tab

  3. In the Editing group, choose Sort & Filter → Filter

Small dropdown arrows will appear beside each column heading. These arrows allow you to sort or filter the data in that column.

Sorting Data Alphabetically

Sorting rearranges the rows in a worksheet based on the values in one column.

For example, you can sort a list of people by last name.

To do this:

  1. Click the dropdown arrow in the column heading

  2. Select Sort A to Z

Excel will reorganize the rows so the values appear in alphabetical order.

Even though the rows change position, all the data within each row remains together. This means each person's information stays grouped correctly.

Understanding What Happens When Data Is Sorted

When you sort by a column, the order of other columns may appear to change.

For example, if the worksheet includes a client number column, those numbers may no longer appear in numerical order after sorting by last name.

This happens because Excel reorganizes entire rows, not individual cells.

The data stays consistent because every row moves as a complete unit.

Filtering Data

Filters allow you to temporarily display only certain rows of data.

For example, you might want to show only:

  • a specific category

  • certain values

  • a subset of records

To filter data:

  1. Click the dropdown arrow in a column heading

  2. Deselect the items you do not want to display

Excel will hide the rows that do not match the selected criteria.

Hidden Rows Are Not Deleted

When filters hide rows, the data is not deleted.

Excel simply hides the rows from view.

You can recognize filtered data because the row numbers on the left side of the worksheet will skip numbers where hidden rows exist.

Clearing Filters

To restore the full dataset:

  1. Click the filter icon in the column heading

  2. Select Clear Filter

All hidden rows will become visible again.

Combining Multiple Filters

Filters become even more powerful when used across multiple columns.

For example, if a worksheet includes many categories such as:

  • name

  • occupation

  • gender

  • location

you can apply filters to several columns at once.

Excel will display only the rows that match all selected conditions, allowing you to isolate specific subsets of data.

Why Sorting and Filtering Are Useful

Sorting and filtering can help you quickly analyze data without changing the original structure of the worksheet.

These tools allow you to:

  • organize information alphabetically or numerically

  • isolate specific categories

  • temporarily hide irrelevant data

Although this example used a small dataset, the same tools can manage worksheets containing hundreds or thousands of rows.

Related Excel Tutorials