- Using the Ribbon
- Using the Quick Access Toolbar
- Using the Full-Screen File Menu
- Using Other Excel Interface Improvements
- Using the New Sheet Icon to Add Worksheets
- Navigating Through Many Worksheets Using the Controls in the Lower Left
- Using the Mini Toolbar to Format Selected Text
- Expanding the Formula Bar
- Zooming In and Out on a Worksheet
- Using the Status Bar to Add Numbers
- Switching Between Normal View, Page Break Preview, and Page Layout View Modes
This chapter is from the book
This chapter is from the book
This chapter is from the book
Navigating Through Many Worksheets Using the Controls in the Lower Left
Previous versions of Excel had four controls for moving through the list of worksheet tabs. Due to the new “less chrome” mantra, the worksheet navigation icons are now a left and right arrowhead in the lower left (see Figure 3.32).
)
Figure 3.32. These worksheet navigation controls have been streamlined in Excel 2013.
The controls are only active when you have more tabs than are visible across the bottom of the Excel window. Click the left or right icon to scroll the tabs one at a time. Ctrl+click either arrow to scroll to the last tab. Note that scrolling the tabs does not change the active sheet. It just brings more tabs into view so you can then click the selected tab.
Just as in prior versions of Excel, you can right-click the worksheet navigation arrows to see a complete list of worksheets. Click any item in the list to move to that worksheet.
In certain circumstances, an ellipsis (...) icon appears in the worksheet navigation area. This icon selects the worksheet to the left of the active sheet.