You can change the sort order of columns. In this video, learn how to sort by column and display data in a random order.
- [Instructor] It's common to want to sort data … based on the contents of one particular column. … You'll first need to freeze your header row if you have one, … by going to View, … Freeze, 1 row. … Next, hover your mouse over the column you want to sort by … and click the down triangle that appears. … From here, you can choose to sort sheet … from A to Z, or Z to A. … You can also display these in a random order. … This is useful if you're trying … to determine a contest winner. … You need to start by selecting everything, which you can do … by clicking once in the top left most grid. … From here, repeat the process to click the down triangle … and now choose randomize range. … All the data will now be displayed in a random order, … though, still everything is in its appropriate row. … If you were looking for a contest winner, … you can choose the top most row. … …
- Wrapping text
- Collaborating with others on a spreadsheet
- Freezing and locking panes
- Auto-filling data quickly
- Rotating cell data
- Formatting spreadsheets
- Protecting sheets
- Inserting links
- Filtering views
- Undoing unwanted changes
Skill Level Intermediate
1. Google Sheets Quick Tips
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.