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

248 Reorganizing the Workbook
To use the tab scrolling buttons, click the one with the right-pointing trian- gle to bring the next sheet into view and click the one with the left-pointing triangle to bring the preceding sheet into view. Ctrl-click the tab scrolling buttons with the directional triangles to display the very first or very last group of sheet tabs in a workbook. Ctrl-clicking the button with the triangle pointing left to a vertical line brings the first group of sheet tabs into view; Ctrl-clicking the button with the triangle pointing right to a vertical line brings the last group of sheet tabs into view. When you scroll sheet tabs to find the one you’re looking for, for heaven’s sake, don’t forget to click the desired sheet tab to make the worksheet current.
Excel 2013 indicates that there are more worksheets in a workbook whose tabs are not visible by adding a continuation button (indicated by an ellipsis, that is, three dots in row) either immediately following the last visible tab on the right or the first visible tab on the left. Keep in mind that you can also scroll the next or previously hidden sheet tab into view by clicking the con- tinuation button on the right of the last visible sheet tab or left of the first visible tab, respectively.
Renaming sheets
The sheet tabs shown at the bottom of each workbook are the keys to keep- ing your place in a workbook. To tell which sheet is current, you have only to look at which sheet tab appears on the top, matches the background of the other cells in the worksheet, and has its name displayed in bold type and underlined.
When you add new worksheets to a new workbook, the sheet tabs are all the same width because they all have the default sheet names (Sheet1, Sheet2, and so on). As you assign your own names to the sheets, the tabs appear either longer or shorter, depending on the length of the sheet tab name. Just keep in mind that the longer the sheet tabs, the fewer you can see at one time, and the more sheet tab scrolling you’ll have to do to find the work- sheet you want.
To rename a worksheet, you take these steps:
1. Press Ctrl+PgDn until the sheet you want to rename is active, or click its sheet tab if it’s displayed at the bottom of the workbook window.
Don’t forget that you have to select and activate the sheet you want to rename, or you end up renaming whatever sheet happens to be current at the time you perform the next step.
2. Choose Rename Sheet from the Format button’s drop-down menu on the Home tab, press Alt+HOR, or right-click the sheet tab and then choose Rename from its shortcut menu.