A named range is a way to programmatically reference a group of cells. In this video, learn how to create and edit named ranges.
- [Instructor] You can give a name to a range of cells. … This will help you keep track of them, … as well as create easier to read and write formulas. … To create a named range, start by selecting your cells, … then on the Data toolbar, click Named ranges. … Type a name for your range, and then click Done. … You can now use this word programmatically … and as cell references to access this range. … Click the X to close out of the pane. … To edit or delete your range … click Data, Named ranges, … select your range, and click the pencil icon. … From here, you can rename your range … or click the trashcan icon to delete it. … …
- 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.