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 - Google Sheets Tutorial
From the course: Google Sheets Essential Training
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.