Help & Support
Send Feedback
Sort Range Plus
Sort Range Plus extends Google Sheets's built-in Sort Range tool. It adds the ability to sort rows based on cell background color and text color, not just by cell value. More options are coming soon!
509,259 users
Works with
Install
Overview
Color-code your data and use Sort Range Plus to easily sort your data!

Sort Range Plus extends Google Sheets's built-in Sort Range tool. It adds the ability to sort rows based on cell background color and text color, not just by cell value. More options are coming soon!

Sorting by color is as easy as sorting by values. Simply select your range, choose Sort Range Plus from the Add-on menu, and choose your options.

Sort Range Plus follows the same layout and flow as the Google Sheets built-in Sort Range tool, so it will be familiar to all Sheets users.

v 7.2.2 June 2019
Fix en_us language issue.

v 7.2.1 June 2019

v 7.2.0 June 2019
Error messages when signed into multiple accounts.

v 7.1.0 August 2018
More information about errors. Fixes minor bugs.

v 7.0.1 July 2018
Language support and color sorting settings added
Reviews
A User of Sort Range Plus
November 26, 2019
Does not work. At all.
Submit reply
Cancel
A User of Sort Range Plus
November 13, 2019
Does what is supposed to.
Submit reply
Cancel
A User of Sort Range Plus
October 25, 2019
It does not maintain rows when sorting. Sorted a column of items by colour, but the other information in the rows did not move with the items. Thus it was absolutely useless to me.
Submit reply
Cancel
A user of Sort Range Plus
October 26, 2019
If you want to maintain the rows when sorting by color, then select all the columns in your data. If you want to sort only one column in place, select just that column. This works the same way as the built-in Sheets Sort Range tool.
A User of Sort Range Plus
October 2, 2019
Do not use this. Example: I had filters placed on all my columns before installing. I selected a column, Add-Ons -> Sort, Checked off that I had a column header, filtered by color - - This program then filtered the selected column by color but also shuffled all cells! What was next to that column was no longer in the same row! This ruined the entire spreadsheet. I had to CTRL+Z to undo everything. It also added an empty column for no apparent reason.
Submit reply
Cancel
A User of Sort Range Plus
September 27, 2019
Works great if you read the instructions. Instead of going to Data>Sort got to Add-Ons>Sort Range Plus to sort by color
Submit reply
Cancel
A User of Sort Range Plus
September 26, 2019
Didn't add any new sort ranges
Submit reply
Cancel
A User of Sort Range Plus
September 24, 2019
Added nothing to the Sorting ability.
Submit reply
Cancel
A User of Sort Range Plus
June 5, 2019
sorting was incorrect, leaving still some of black rows intermixed with the green ones, while a part of the spreadsheet was sorted correctly.
Submit reply
Cancel
A user of Sort Range Plus
June 10, 2019
Hi Daniel, would be happy to help you with this if you can provide more info! You can email us at help@mgdgoods.com and we'll take a look.
Lexi Lee
May 30, 2019
Useful function aside from the fact that there is no way to unsort. Can you develop a way to unsort after sorting?
Submit reply
Cancel
A user of Sort Range Plus
June 8, 2019
Hi Lexi, you can easily unsort by selecting Undo twice from the Edit menu (or Ctrl/Cmd-Z). Just remember to do it twice to unsort your data.
A User of Sort Range Plus
October 13, 2018
Thank you so much !!
Submit reply
Cancel
1-10 of 15
Additional information
Search
Clear search
Close search
Google apps
Main menu