How to Sort Data in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to sort data in an Excel worksheet in just a few clicks.

Quick summary

Sorting data in Microsoft Excel lets you quickly organize rows in ascending or descending order using the built-in Sort & Filter tool. This step-by-step guide shows you how to select cells, access the sort options, and apply your preferred order in seconds.

Steps

Select the cells in your Microsoft Excel worksheet that contain the data you want to sort.
Go to the top menu bar and click Sort & Filter under the Home tab.
Choose your preferred sort order from the list of available options.
Your selected data will be sorted automatically based on your chosen input.

📌 Why this matters

Sorting data in Microsoft Excel is a fundamental skill that helps users organize large datasets quickly and accurately. The Sort & Filter feature allows you to arrange rows in ascending or descending order with just a few clicks, saving significant time compared to manual reordering. Whether you are managing financial records, inventory lists, or project data, knowing how to sort in Excel improves data readability and analysis efficiency. This interactive demo makes it easy to learn the exact steps without needing prior Excel experience.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel