Sort vs Filter vs Slicers: How to Organize Data in Excel

Sorting, filtering and slicers all help you make sense of a big list, but they do different jobs:

ToolWhat it doesUse it when
SortChanges the order of rowsYou want to rank or group data (largest to smallest, A–Z)
FilterHides rows that don’t matchYou want to see only certain rows (one region, one month)
SlicersClickable filter buttonsOthers will use the sheet, or you’re building a dashboard

Before you start, make sure your data has one header row and no completely blank rows or columns in the middle.

Sorting

Quick sort by one column

  1. Click any cell in the column you want to sort by (don’t select the whole column).
  2. Go to Data → Sort A to Z or Sort Z to A.

Excel sorts the entire table and keeps each row together.

Sort by several columns

Example: sort by Department A–Z, then by Sales largest to smallest within each department.

  1. Go to Data → Sort.
  2. Make sure My data has headers is ticked.
  3. Sort by Department, Order A to Z.
  4. Click Add Level. Then by Sales, Order Largest to Smallest.
  5. Click OK.

Custom sort order

To sort by something that isn’t alphabetical, like High, Medium, Low, choose Order → Custom List in the Sort dialog and type your order.

Warning: never select a single column and sort only that column. Excel will ask whether to expand the selection; always choose Expand the selection, or your rows will get mixed up.

Filtering

Turn on filters

Click inside your data and press Ctrl + Shift + L (or Data → Filter). A dropdown arrow appears in each header.

Filter by values

Click an arrow, untick Select All, then tick the values you want to see.

Filter by conditions

  • Text Filters: contains, begins with, does not equal.
  • Number Filters: greater than, between, top 10, above average.
  • Date Filters: this month, last quarter, between two dates.

Filtered columns show a funnel icon, and row numbers turn blue so you know rows are hidden.

Clear filters

Use Data → Clear to show all rows again while keeping filter arrows, or press Ctrl + Shift + L to remove filters completely.

Total only the visible rows

SUM adds hidden rows too. To total only what’s visible after filtering, use SUBTOTAL:

=SUBTOTAL(9, C2:C500)

The 9 means SUM. Excel tables add this automatically in the Total Row.

The FILTER function (Excel 365)

Instead of hiding rows, the FILTER function copies matching rows to another place and updates automatically:

=FILTER(A2:D500, B2:B500="North", "No results")

This returns every row where column B is “North”. It’s great for live reports on a separate sheet. Pair it with SORT to order the results: =SORT(FILTER(A2:D500, B2:B500="North"), 4, -1).

Slicers

Slicers are buttons that filter a table or pivot table with one click. They’re easier for colleagues than filter dropdowns and they show clearly what’s selected.

  1. Convert your data to a table with Ctrl + T (or use a pivot table).
  2. Click inside the table and go to Table Design → Insert Slicer (for pivot tables: PivotTable Analyze → Insert Slicer).
  3. Tick the columns you want slicers for, such as Region and Month.
  4. Click buttons to filter. Hold Ctrl to select several, and click the clear icon (funnel with an X) to reset.

Slicers are a key part of interactive reports; see how they fit into a simple Excel dashboard.

In Google Sheets

Use Data → Sort range for sorting, Data → Create a filter for filters, and Data → Add a slicer for slicers. Google Sheets also has Filter views, which let each person filter the data without changing what others see, ideal for shared files.

Which one should you use?

  • Need a ranking or ordered list? Sort.
  • Need to focus on a subset for a moment? Filter.
  • Need a live list somewhere else? FILTER function.
  • Building something others will click through? Slicers.

FAQ

What is the difference between sort and filter in Excel?
Sorting changes the order of all rows (for example A–Z or largest to smallest). Filtering hides the rows that do not match, without changing the order of the rest.

What is the difference between a slicer and a filter?
A slicer is a set of clickable buttons for filtering a table or PivotTable. It does the same job as a filter but is easier to see and use, which makes it great for dashboards.

Does sorting break my data?
Not if you sort the whole table. Click one cell inside the data before sorting, or convert the range to an Excel table, so every column moves together.

Can I use slicers without a PivotTable?
Yes. Convert your range to a table (Ctrl + T), then go to Table Design → Insert Slicer.

Related guides

Leave a Comment