Recommended for G SuiteWorks with Google DriveWorks with GmailWorks with CalendarWorks with DocsWorks with SheetsWorks with SlidesWorks with Forms
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!
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
English (United States)
All languages
Recent
Helpful
A User of Sort Range Plus
November 26, 2019
Does not work. At all.
A User of Sort Range Plus
November 13, 2019
Does what is supposed to.
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.
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.
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
A User of Sort Range Plus
September 26, 2019
Didn't add any new sort ranges
A User of Sort Range Plus
September 24, 2019
Added nothing to the Sorting ability.
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.
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?
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 !!
1-10 of 15
Additional information
Recommended for G Suite
Most Popular
Top Rated
Works with Google Drive
Works with Gmail
Works with Calendar
Works with Docs
Works with Sheets
Works with Slides
Works with Forms
Communication
Utilities
Productivity
Creative Tools
Web Development
Office Applications
Task Management
Education
Academic Resources
Teacher & Admin Tools
Search
Clear search
Close search
Google apps
Main menu