You can choose to only display data that meets certain criteria. In this video,learn how to create and edit filters in Google Sheets.
- [Instructor] Use a filter to hide data … that does not meet specific criteria. … From the toolbar icon, click Create a filter. … In the particular column … that you want to filter the view for, … click the three horizontal lines. … You can filter by color, condition or values. … I'll start by clicking Clear … to remove existing values from the column, … and I'll place checkmarks … next to the data that I want to see. … Click OK. … And your view will only show you the data that you selected. … Click the filter icon again … and choose Select all to make sure everything's back. … Filter by condition will allow you to select a pulldown … of existing values that you can test on. … For example, if you only want to see data … that contains empty cells, … you can choose Is Empty. … We can also do the opposite … by only seeing data that is not empty. … When you're all done with your filter, … from the toolbar icon, click Turn off filter. … …
- 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.