You can add more sheets to your Google Sheet. In this video, learn how to add a sheet, rename it, and reference it in a cell.
- [Instructor] You can insert a new sheet by clicking the plus sign at the bottom left-hand side of the screen. Rename the sheet by double-clicking inside, typing your new name and hitting the enter key on your keyboard. Now you can populate that sheet as necessary. You can reference the sheet programmatically by using the name of the sheet plus an exclamation mark. This is referencing the text in cell A1 in the category sheet. Use an apostrophe if the title of the sheet is more than one word. Google Sheets will automatically update the name if you rename it. Right-click on the sheet name and choose Rename.
- 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.