Can You Sort by Color in Google Sheets
Sorting past color in Google Sheets is simply a few mouse clicks or screen taps abroad.
Google added this capability to the Sheets app in March of 2020. You can use the color sorting to arrange cells past both fill (groundwork) and text color.
Enabling the Sort by Color functionality
Google Sheets enables the color sorting characteristic by default, simply y'all need to turn on filtering to employ information technology.
The following steps enable sorting past color for both fill and text:
- Click or tap on one of the header row cells in the spreadsheet.
- Click or tap the "Filter" icon located on the far right of the menu bar (it will say "Create a Filter on mouseover).
- This volition enable sorting and filtering for all columns with data in the spreadsheet. The filter icon will appear to the right of the text in the header.
When yous click on the filter option in the column (which has the cells with the background colour), it will show yous options that you tin can use to sort past color in Google Sheets.
How to Sort past Fill Color
The following steps explain how to use Sort past Make full Color:
- Select the filter icon next to the header for the column you want to sort past color.
- From the drib card, select "Sort past colour," then "Fill up Color", and choose the fill color you want to announced on top. The example shows selecting "low-cal red i".
- The spreadsheet will now show "light crimson 1" colored cells starting time.
Performing the aforementioned sort on a spreadsheet that has multiple cells with repeated colors volition group the cells that share the selected colour.
- Use a spreadsheet with colors used multiple times:
- Utilise sort by colour, the example uses "light red 1."
- All cells using the selected fill color will appear at the summit of the spreadsheet.
Note: Sort by color simply applies to the selected colour. You lot volition demand to repeat the sort for each colour if you lot want all cells grouped by color.
Using Sort by Text Color
The following steps explain how to use Sort past Fill up Color:
- Select the filter icon side by side to the header for the cavalcade yous want to sort by color.
- From the drib menu, select "Sort by colour," then "Text Color", and choose the text color you desire to appear on elevation. The instance shows selecting "dark green 1".
- All cells using the selected text color will announced at the top of the spreadsheet.
Note: Sort by color only applies to the selected color. In this case, the red cells were already grouped together so sorting the green cells together grouped all the colors together.
Use the Filter to Show Individual Color Groups
The "Filter past color" option makes it easy to display merely cells that feature a specific color. The following steps explain how to filter by color.
- Select the filter icon from the header for the column you desire to use.
- From the drop menu, select "Filter by color," either "Make full Color" or "Text Color," and the desired color you desire to show. The case demonstrates using "low-cal blue 1" as a fill color.
- The spreadsheet will now merely show rows with the chosen color.
Notation: You can turn off the filter by selecting the filter icon, selecting "Filter by colour" and choosing "None."
Agreement Sorting Behavior
Sorting by color behaves differently from sorting by numerical sequence or in alphabetical society. Google Sheets does non employ a sorting value to colors in the same way information technology does with numbers and letters. Instead, Google Sheets opts for a manually controlled sorting method.
The main rule you demand to know when sorting by colour in Google Sheets is the app will always move all rows with the chosen color to the top of the spreadsheet. However, the sort will not alter the arrangement of cells that utilize any other color.
If you want to sort past colour in a specific order, you will need to manually employ the sort command for each color. The society needs to start with the colour yous want on the bottom and piece of work upwards through the arrangement so the last sorted color is on peak.
If yous take a spreadsheet with "red," "blue," and "greenish" fill colour rows, you volition need to sort multiple times to alter the order. If you desire to rearrange the rows into a "green," "crimson," to "blue" order, you outset by sorting "blue," the last colour, kickoff. Next, utilise the "red" sort and then end with the "green" sort. This will arrange the rows in the desired "green-red-bluish" order.
Because of the transmission nature of ordering sorted colors, the more than colors y'all use, the more fourth dimension-consuming it gets. A spreadsheet with fewer colors will be easier to manage.
Avant-garde Uses
Google Sheets supports using both fill and text color sorting at the same fourth dimension. Withal, it can be challenging to manage the order in a spreadsheet that uses both fill and text sorting. Instead, using fill up color for sorting and text color for filtering opens up all sorts of new uses for these features.
For example, let'due south take this dataset representing a family. The three brothers are using the fill color green, their spouses are bluish, and their children are cherry. By using the text color white, we can represent another information point like "July Birthdays."
If we apply the filter to show but white colour text, we can show but the family members with July birthdays while preserving the color sort order.
Google Sheets color sorting is:
- Ideal for group row content by fill and text color.
- Easy to use for sorting rows with cells that share a fill or text colour at the top.
- Applied for filtering past make full or text color to show simply ane colour group at a fourth dimension.
- Non a viable solution if you expect colors to arrange similarly to alphabetical or numerical organization automatically on a massive calibration.
This how-to guide describes a native solution for using colour sorting in Google Sheets. However, color sorting existed in Microsoft Excel long before it did in Google Sheets.
The Google Sheets community members adult multiple scripts and add-ons to manually create this formerly missing feature.
Sorting by color is an splendid addition to the Google Sheets feature set which further aligns information technology with Microsoft Excel capabilities.
Color sorting adds practical functionality from family budgeting to production management employ. Sorting past color makes Google Sheets a more powerful, useful, and easy-to-use awarding.
So these are the means you can sort by color in Google Sheets.
Sumit
Google Sheets and Microsoft Excel Expert.
Source: https://productivityspot.com/sort-by-color-google-sheets/
0 Response to "Can You Sort by Color in Google Sheets"
Enregistrer un commentaire