non-Ribbon commands to the Quick Access toolbarYou can also use the options on the Quick Access Toolbar tab of the Excel Options dialog box (refer to Figure 1-6) to add a button for any Excel command even if it isn’t one of those displayed on the tabs of the Ribbon:
1. Select the type of command you want to add to the Quick Access toolbar in the Choose Commands From drop-down list box.
The types of commands include the Popular Commands pull-down menu (the default) as well as each of the tabs that appear on the Ribbon. To display only the commands that are not displayed on the Ribbon, select Commands Not in the Ribbon near the top of the drop-down list. To display a complete list of the Excel commands, select All Commands near the top of the drop-down list.
2. Select the command button you want to add to the Quick Access toolbar in the list box on the left.
3. Click the Add button to add the command button to the bottom of the list box on the right.
4. (Optional) To reposition the newly added command button so that it isn’t the last one on the toolbar, click the Move Up button until it’s in the desired position.
5. Click OK to close the Excel Options dialog box.
The Formula bar displays the cell address (determined by a column letter[s] followed by a row number) and the contents of the current cell. For example, cell A1 is the first cell of each worksheet at the intersection of column A and row 1; cell XFD1048576 is the last cell of each worksheet at the intersection of column XFD and row 1048576. The type of entry you make determines the contents of the current cell: text or numbers, for example, if you enter a heading or particular value, or the details of a formula, if you enter a calculation.
The Formula bar has three sections:
❯❯ Name box: The left-most section that displays the address of the current cell address.
❯❯ Formula bar buttons: The second, middle section that appears as a rather nondescript button displaying only an indented circle on the left (used to narrow or widen the Name box) and the Insert Function button (labeled fx) on the right. When you start making or editing a cell entry, Cancel (an X) and Enter (a check mark) buttons appear between them.
❯❯ Cell contents: The third, right-most section to the immediate right of the Insert Function button takes up the rest of the bar and expands as necessary to display really long cell entries that won’t fit in the normal area.
When it comes to labeling the 16,384 columns of an Excel 2016 worksheet, our alphabet with its measly 26 letters is simply not up to the task. To make up the difference, Excel doubles the letters in the cell’s column reference so that column AA follows column Z (after which you find column AB, AC, and so on) and then triples them so that column AAA follows column ZZ (after which you get column AAB, AAC, and the like). At the end of this letter tripling, the 16,384th and last column of the worksheet ends up being XFD so that the last cell in the 1,048,576th row has the cell address XFD1048576!
The Worksheet area is where most of the Excel spreadsheet action takes place because it’s the place that displays the cells in different sections of the current worksheet and it’s right inside the cells that you do all your spreadsheet data entry and formatting, not to mention a great deal of your editing.
❯❯ The cell cursor – the dark green border surrounding the cell’s entire perimeter – appears in the cell.
❯❯ The address of the cell appears in the Name box of the Formula bar.
❯❯ The cell’s column letter(s) and row number are shaded in the column headings and row headings that appear at the top and left of the Worksheet area, respectively.
An Excel worksheet contains far too many columns and rows for all a worksheet’s cells to be displayed at one time, regardless of how large your computer’s monitor screen is or how high the screen resolution. (After all, we’re talking 17,179,869,184 cells total!) Therefore, Excel offers many methods for moving the cell cursor around the worksheet to the cell where you want to enter new data or edit existing data:
❯❯ Click the desired cell – assuming that the cell is displayed within the section of the sheet visible in the Worksheet area – either by clicking it with your mouse or tapping it on your touchscreen.
Click the Name box, then type the address of the desired cell and press the Enter key.
❯❯ Press F5 to open the Go To dialog box, type the address of the desired cell into its Reference text box, and then click OK.
❯❯ Use the cursor keys, as shown in Table 1-1 to move the cell cursor to the desired cell.
❯❯ Use the horizontal and vertical buttons located at the ends of the scroll bars found at the bottom and right edge of the Worksheet area to move to the part of the worksheet that contains the desired cell and then click or tap the cell to put the cell cursor in it.
TABLE 1-1 Keystrokes for Moving the Cell Cursor
Note: In the case of those keystrokes that use arrow keys, you must either use the arrows on the cursor keypad or else have the Num Lock disengaged on the numeric keypad of your keyboard.
Excel offers a wide variety of keystrokes for moving the cell cursor to a new cell. When you use one of these keystrokes, the program automatically scrolls a new part of the worksheet into view, if this is required to move the cell pointer. In Table 1-1, I summarize these keystrokes, including how far each one moves the cell pointer from its starting position.
The keystrokes that combine the Ctrl or End key with an arrow key listed in Table 1-1 are among the most helpful for moving quickly from one edge to the other in large tables
