From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 23,200 courses taught by industry experts.

Use keystroke and mouse shortcuts to display and navigate worksheets

Use keystroke and mouse shortcuts to display and navigate worksheets - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use keystroke and mouse shortcuts to display and navigate worksheets

“

- [Instructor] In Excel, there are any number of different techniques to make you more efficient as you work with a multi-sheet workbook or if you've got multiple files open. We sometimes refer to these as navigation tools. I've just opened a workbook here that either I haven't seen in a long, long time, it doesn't look familiar, or maybe it's something out of the past. I'm trying to figure out what's going on here. First order of business, let's scope out these sheets. In the lower left corner, you'll see a gray panel with a couple of arrows in them. Often one of them is gray. If you right click in the lower left corner, you will see a list of all the worksheet names and the top-down order that we see here does correspond with the left to right order, but you're much more likely to see all of them if you have many sheets here. If there are more than 20 sheets, there will be a scroll bar on the right-hand side that's…

Contents