How to SORT Data in Excel | 7 Tips

Posted on: 08/03/2022 How to SORT Data in Excel | 7 Tips

Excel has a powerful SORTING engine. SORT is the most popular function in Excel, and it can sort by many types of data, many attributes, and even custom sorting configurations.

In this article and video, I walk you through 7 major SORT feature tips and procedures. We look at ensuring the data is ready to sort, selecting the appropriate sorting range, and ensuring there are no blank rows or columns.

Then we sort in Excel by one column, multiple columns, by color, by date, custom sorting, and also sorting mixed data, ensuring that if we have numbers and numbers stored as text, we can correct that and still sort the data properly.

Outlook Contact Group from Excel data

YouTube Video on Sorting

Video Chapters:

00:00 Introduction
00:46 Check your data
02:05 Sort by one column
04:31 Sort by multiple columns
06:47 Sort by color
09:03 Sort by month
09:59 Custom sort
12:24 Sort mixed data
16:11 Closing remarks

Sort by Color in Excel

To sort by color in Excel:

Go to the Data tab. Click Sort.
Selec t the field you want to sort by. Change the Sort On to Cell Color. You can also sort by Font color.
Select the Order and pick the color you want to sort by. Continue selecting colors and click OK when done.

**Excel sort by color - select the color**

Recent articles

Microsoft Teams - Save Chat and Channel Messages is Back!

Learn how to save and organize chat and channel messages in Microsoft Teams—step-by-step saving, viewing saved items, filters, and practical productivity tips.

Master Microsoft Teams Follow Threads to Boost Your Productivity

Discover how the new Microsoft Teams Follow Threads feature helps you stay organized by easily tracking important conversations. Learn how to follow, manage, and customize your thread notifications.

Nov 4, 2025 - Executive Insights: Harnessing Excel for Strategic Analysis

Nov 4, 2025 - Join us on November 4, 2025, for a live, in-person training: Executive Insights – Harnessing Excel for Strategic Analysis. Learn how to master Power Query, PivotTables, data cleaning, sorting and filtering, conditional formatting, and charts to create impactful reports and support leadership with confidence. Perfect for Executive Administrative Professionals looking to boost efficiency and deliver data-driven insights.

August 19, 2025 - Southeastern Accounting Show (SEAS) - The CPA's Guide to Excel Data Analysis - Chris Menard

I will be presenting at the Georgia Society of CPAs Southeastern Accounting Show on August 19, 2025. My first session will be The CPAs Guide to Excel Data Analysis: Turning Numbers into Knowledge

Summarize Outlook Attachments with Copilot

In today’s fast-paced digital world, managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot

Teams and Outlook: Keeping Teams and Outlook Contacts in Sync

Discover how the new synchronization feature between Microsoft Teams and Outlook can streamline your contact management, enhance productivity, and reduce errors.

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and Microsoft Most Valuable Professional (MVP). Chris works as a Senior Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel featuring over 900 technology videos that cover various apps, including Excel, Word, PowerPoint, Zoom, Teams, Coilot, and Outlook. To date, the channel has had over 25 million views. Menard also participates in 2 to 3 public speaking events annually, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.