This video discusses how to quickly find named ranges of cells and other named content in an Excel workbook.
(upbeat music)…- [Instructor] In Microsoft Excel you can apply names…to ranges of cells, functions, constants, or tables…in order to make it easier to keep track…of complex content in your workbooks.…Once you've added names to your content,…it's very easy to track down ranges of cells…and other content by name.…To do so, go to the Home ribbon…and then click the Find & Select button, and choose Go To.…
In this window you'll find a list of all the names…you've applied to content in your workbook.…Just double-click the name you want,…and that section of your workbook…will instantly pop up on screen.…
- Working with references
- Freezing and locking
- Automatic data population
- Recovering lost work
- Finding named ranges
- Formatting cells and applying styles
- Applying international currency formatting
- Inserting hyperlinks
- Creating dropdown lists
- Hiding columns and rows
- Password protecting a workbook
- Restricting editing
- Adding headers and footers
- Locking cells
Skill Level Intermediate
1. Excel 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.