diTii.com Digital News Hub

Sign up with your email address to be the first to know about latest news and more.

I agree to have my personal information transfered to MailChimp (more information)


Google Docs Spreadsheets “Advanced Sorting Rules”

One new feature of Google spreadsheets that helps organize your data is advanced sorting rules:

Sorting a selection. With new sorting capabilities, you can sort a small selection of cells without affecting rest of your spreadsheet. First, highlight range of cells in a spreadsheet, then, go to Tools menu and select Sort. Now you can set a sorting rule. Last, click Sort button.

You can set multiple sorting rules for any given selection of cells. If you select just the data about running again, you can sort first by distance and then by time to more easily see your average time. Click +Add another to add additional sorting rules.

Alternatively, you can sort entire sheet. Click square in top left corner of your spreadsheet to select all cells in your spreadsheet. Once you’ve selected all of the cells in your sheet, you can set your sorting rules in the same way as sorting a selection.

detailed look at sorting. The title of your sorting pop-up will tell you what range of cells highlighted to be sorted. If it’s wrong, click Cancel and try again. If your columns have titles, you’ll want to check Data has header row box. Next, you’ll be able to choose what columns you’d like to sort by in drop down menu next to sort by. If you’d like to add multiple rules, click +Add another until you’re done setting your sorting rules. When you’re done, click Sort button, and voila!


Share This Story, Choose Your Platform!