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.

 

 

Sort data in Excel - 7 tips

Sort data in Excel - 7 tips

 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
Disney Event with Chris Menard in September 2022

Sort by Color in Excel

To sort by color in Excel:

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

Excel sort by color

Excel sort by color - select the color

Excel sort by color - select the color

Recent articles

Teams - Change your status in Teams | Duration and Status Message

Teams - Change your status in Teams | Duration and Status Message

Teams Online Couse - New material added

Teams Online Couse - New material added

Calculated Items in an Excel PivotTable

Calculated Items in an Excel PivotTable

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Excel VLOOKUP for Tax Brackets Year 2021 with Examples

Outlook Calendar - Meetings vs. Appointments

Outlook Calendar - Meetings vs. Appointments

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Outlook Contact Group - Distribution List - Schedule a Meeting Trick - Huge Timesaver

Chris Menard

Chris Menard is a Microsoft Certified Trainer (MCT) and is employed full-time as a Trainer for BakerHostetler, one of the nation’s largest law firms. Menard has a YouTube channel with over 800 technology videos covering Excel, Word, Zoom, Teams, Outlook, Gmail, Google Calendar, and other resources that over 12 million viewers have appreciated. Menard also does public speaking at conferences for CPAs and Administrative Professionals. Connect with Chris on LinkedIn at chrismenardtraining.com/linked or on YouTube at chrismenardtraining.com/youtube

Categories