![Step-by-Step Guide: Organizing Data by Hue in MS Excel](https://thmb.techidaily.com/071483303e8a1f6026bf0da4b7a67ab78d5daef3d5d188bd12d3a2359c4d77ed.jpg)
Step-by-Step Guide: Organizing Data by Hue in MS Excel
![](/images/site-logo.png)
Step-by-Step Guide: Organizing Data by Hue in MS Excel
Quick Links
Using Microsoft Excel’s sorting feature , you can sort your cells that are either manually colored or conditionally colored by their color. This works for multiple colors and we’ll show you how to implement it in your spreadsheets.
- With your spreadsheet open, in the ribbon click Data > Sort.
- In the “Sort By” dropdown menu select the column you want the data sorted by.
- From the “Sort On” list, select “Cell Color,” then choose a color and location for sorting.
- Add as many levels as needed, then click “OK.”
With the feature, you can place the cells containing a specific color at the top or the bottom of the list. For example, you can place all your green-colored cells at the top while keeping all the red ones at the bottom.
You can sort by a cell’s background color as well as the font color, as we’ll explain below.
Related: How to Sort and Filter Data in Excel
Sort Data by Cell Color or Font Color in Excel
To start sorting , open your spreadsheet with Microsoft Excel. In your spreadsheet, click any cell in your dataset.
From Excel’s ribbon at the top , select the “Data” tab.
On the “Data” tab, from the “Sort & Filter” section, choose “Sort.”
A “Sort” window will open. If your dataset has headers, then in this window’s top-right corner, enable the “My Data Has Headers” option.
Click the “Sort By” drop-down menu and select the column whose data you want to sort. From the “Sort On” drop-down menu, if you want to sort your cells by their background color, choose “Cell Color.” To sort cells by their font color, select “Font Color.” We’ll go with the former option.
Next, click the “Order” drop-down menu and choose the color you want to keep at the top or at the bottom. Next to this drop-down, click another drop-down and select where you want to place the cells containing the selected color. Your options are “On Top” and “On Bottom.”
If you have three or more color cells in your dataset, feel free to add another sorting level by clicking “Add Level” at the top of the “Sort” window.
Finally, at the bottom of the window, click “OK” to apply your changes.
Back on your spreadsheet window, you will see your cells sorted by their color.
If you’d like to undo your changes, then quickly press the Ctrl+Z (Windows) or Command+Z (Mac) keyboard shortcut. This will remove the sorting you’ve applied to your dataset.
And that’s how you quickly filter your data using your cells’ color in Excel spreadsheets. Very useful!
Did you know you can sort your Excel data by date as well? Check out our guide to learn how.
Related: How to Sort by Date in Microsoft Excel
Also read:
- [New] In 2024, Unlock Creative Potential with XP’s Movie Creation Toolkit
- [New] Step-By-Step Saving Tweet Vids on Androids for 2024
- [New] Total Horizon Capture Versus Focused Dimensionality for 2024
- [Updated] 2024 Approved Unparalleled Tech for Capturing Live Screens & Videos
- [Updated] Evaluating Cloud Options Price & Performance for 2024
- [Updated] Master Your Creative Process Essential Affects Plugin Guide for 2024
- [Updated] Quick Fixes for Color Balancing in PS
- Data Integrity Issue Solved: Correcting CRC (Cyclic Redundancy Check) Mistakes
- Effective Remedies for Overcoming Window's Updates Troublesome Error 0X80240017
- Expert Guide - Resolving Problems When Teredo Does Not Qualify Network Access
- Expert's Top 10 FCP Plugin Selection
- How to Fix the Windows 11 0X80240034 Update Error
- In 2024, How to Unlock Apple ID Activation Lock From iPhone 6 Plus?
- Resolved Issue: Unintended Letter Selection When Typing
- Step-by-Step Tutorial: Combat Computer Stalling and Restore Performance
- Stop Laptop Frustrations: Charge That Battery in No Time with These Fixes!
- Why Your USB Connectors Aren’t Working in Windows 11? Here's the Fix
- Title: Step-by-Step Guide: Organizing Data by Hue in MS Excel
- Author: Anthony
- Created at : 2025-01-22 16:23:27
- Updated at : 2025-01-25 17:25:04
- Link: https://win-howtos.techidaily.com/step-by-step-guide-organizing-data-by-hue-in-ms-excel/
- License: This work is licensed under CC BY-NC-SA 4.0.