If your data is hard to read, you can alternate the colors of every other row. In this video, learn where this functionality is and how to customize the colors of each row and header.
- [Instructor] If you have a long list of data, … it can be hard to figure out … which row goes with which corresponding piece of data. … You can alternate the colors so it's easier to read. … Click format and then choose alternating colors. … Google Sheets is smart enough to realize … where your data ends, … and we'll choose that as the range, … but you can change this if it gets it wrong. … It can also recognize if you have a header or not, … and it will make that header a different color. … You can choose from default styles … and you can also create your own custom styles. … You can choose an individual color for the header … and a color for each alternating row. … You can close the pane when you're done, … and if you decide you don't want alternating colors, … click remove alternating colors at the bottom of the screen. … …
- 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.