From the course: Google Sheets Essential Training

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Sorting data on a spreadsheet

Sorting data on a spreadsheet - Google Sheets Tutorial

From the course: Google Sheets Essential Training

Start my 1-month free trial

Sorting data on a spreadsheet

- [Instructor] In Google Sheets, you can sort your data based on rules you set for one or more columns. You can sort a column so that the other columns in this spreadsheet are sorted along with it, or you can sort a column on its own. You can also start multiple columns in priority order. Sorting columns can be handy for looking at your data in different ways quickly without setting up filter views or pivot tables. Let me show you how sorting columns works in Google Sheets. I'll show you on this sales spreadsheet. You'll find this as the file named "Sort" in the "Exercise Files Chapter Four" folder. Most commonly, you'll want to sort your spreadsheet on a single column, and you'll want to have the other columns in the spreadsheet sorted along with it, so you don't mess up your data. The simplest way to do that is to use the sorting arrow in the column header. If you have a header row, like I do on this sheet, first…

Contents