From the course: Excel 2016: Tips and Tricks
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Navigate between worksheets efficiently
From the course: Excel 2016: Tips and Tricks
Navigate between worksheets efficiently
- [Voiceover] When you open a workbook that you're not too familiar with, you're probably curious about the sheet tabs, maybe how many there are and what they're called. In the lower left-hand corner there's a gray panel with two arrows, sometimes one of them is grayed out. These are referred to as navigation arrows. All the versions of Excel would have had four arrows. I'm going to right-click in that gray panel and this activates the Activate dialog box. This shows us as many as 20 worksheets. If this workbook has more than 20 worksheets, you'll see a scrollbar on the right-hand side. Now at the bottom of the screen we're only seeing four sheet tabs at the moment. But what we're seeing there is reflected in this list. The top-down order of the list here corresponds with the left to right order of the sheet tabs at the bottom of the screen. So Employees, Profits, HR List, ProjBudget2017, we're seeing those. Now, think of this as almost like a table of contents. I want to go to the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.