Page 51 - Excel 2013 All-in-One For Dummies

Excel’s Ribbon User Interface 33 Surfing the sheets in a workbook
Each new workbook you open in Excel 2013 contains a single blank work- sheet, aptly named Sheet1, with 16,384 columns and 1,048,576 rows (giving you a truly staggering total of 51,539,607,552 blank cells!). Should you still need more worksheets in your workbook, you can add them simply by click- ing the New Sheet button (the circle with the plus sign in it) that appears to the immediate right of Sheet1 tab.
On the left side of the bottom of the Worksheet area, the Sheet tab scroll buttons appear, followed by the actual tabs for the worksheets in your work- book and the New Sheet button. To activate a worksheet for editing, you select it by clicking its sheet tab. Excel lets you know what sheet is active by displaying the sheet name on its tab in green, boldface type as well as under- lining the tab and making the tab appear to be connected to the current worksheet above.
Don’t forget the Ctrl+Page Down and Ctrl+Page Up shortcut keys for selecting the next and previous sheets, respectively, in your workbook. You can also click the Next Sheet and Previous Sheet button marked by the ellipsis (...). The Next Sheet button is the one with the ellipsis on the right side of the sheet tabs immediately left of the New Sheet button. The Previous Sheet button is the one with ellipsis on the left side of the sheet tabs to the immedi- ate left of the first visible sheet tab.
If your workbook contains too many sheets for all their tabs to be displayed at the bottom of the Worksheet area, use the Sheet tab scroll buttons to bring new tabs into view (so that you can then click them to activate them). You click the Next Scroll button (the one with the triangle pointing right)
to scroll the next hidden sheet tab into view on the right and the Previous Scroll button (the one with the triangle pointing left) to scroll the next hidden sheet into view on the left. You Ctrl+click the Next Scroll button to scroll the last sheet into view and Ctrl+click the Previous Scroll button to scroll the first sheet into view.
Right-click either Sheet tab scroll button to display the Activate dialog box listing the names of all the worksheets in the workbook in their order from first to last. Then, to scroll to and select a worksheet, double-click its name or click the name followed by the OK button.
Taking a tour of the Status bar
The Status bar is the last component at the very bottom of the Excel pro- gram window. (See Figure 1-6.) The Status bar contains the following areas:
Book I Chapter 1
The Excel 2013 User Experience