Excel 2016 All-in-One For Dummies. Harvey Greg
Чтение книги онлайн.
Читать онлайн книгу Excel 2016 All-in-One For Dummies - Harvey Greg страница 8
Название: Excel 2016 All-in-One For Dummies
Автор: Harvey Greg
Издательство: John Wiley & Sons Limited
Жанр: Зарубежная образовательная литература
Серия: For Dummies
isbn: 9781119077275
isbn:
The easiest method for selecting commands on the Ribbon – if you know your keyboard at all well – is to press the keyboard’s Alt key and then type the letter of the hot key that appears on the tab you want to select. Excel then displays all the command button hot keys next to their buttons, along with the hot keys for the Dialog Box launchers in any group on that tab. (See Figure 1-5.) To select a command button or Dialog Box launcher, simply type its hot key letter.
Figure 1-5: When you select a Ribbon tab by pressing Alt plus the hot key assigned to that tab, Excel displays the hot keys for its command buttons.
If you know the old Excel shortcut keys from versions prior to Excel 2007, you can still use them. For example, instead of going through the rigmarole of pressing Alt+HCC to copy a cell selection to the Windows Clipboard and then Alt+HVP to paste it elsewhere in the sheet, you can still press Ctrl+C to copy the selection and then press Ctrl+V when you’re ready to paste it.
Selecting Ribbon commands by touch
When selecting Ribbon commands on a touchscreen device without access to a physical keyboard and mouse or touchpad, you are limited to selecting commands directly by touch.
Before trying to select Excel Ribbon commands by touch, however, you definitely want to turn on touch mode in Excel 2016. You do this by tapping the Touch/Mouse Mode button at the end of the Quick Access toolbar followed by the Touch option on its drop-down menu. When you do this, Excel spreads out the command buttons on the Ribbon tabs by putting more space around them, making it more likely that you’ll actually select the command button you’re tapping with your finger (or even a more slender stylus) instead of the one right next to it. (This is a particular problem with the command buttons in the Font group on the Home tab that enable you to add different attributes to cell entries such as bold, italic, or underlining: They’re so close together when touch mode is not on that they’re almost impossible to correctly select by touch.)
What “click and drag” means on your device
Given all the different choices for selecting stuff in Excel, you need to be aware of a few click-and-drag conventions used throughout this book:
✔ When I say “click something” (a command button, cell, or whatever), this means click the primary mouse button (the left one unless you change it) on a physical mouse or tap the object directly with your finger or stylus.
✔ When I say “double-click something,” this means click the primary button twice in rapid succession on a physical mouse or double-tap the object with your finger or stylus.
✔ When I say “right-click,” this means click with the secondary button (the right button unless you change it) on a physical mouse or tap the object and keep your finger or stylus on the touchscreen until the context menu, pop-up gallery, or whatever appears.
✔ When I say “drag through a cell selection,” with a physical mouse this means click the first cell and hold down the primary mouse button as you swipe, and then release the button when the selection is made. On a touchscreen, you tap the first cell and then drag one of the selection handles (the circle that appears in the upper-left or lower-right corner of the selected cell) to make the selection.
When you first begin using Excel 2016, the Quick Access toolbar contains only the following three or four buttons:
✔ Save: Saves any changes made to the current workbook using the same filename, file format, and location.
✔ Undo: Undoes the last editing, formatting, or layout change you made.
✔ Redo: Reapplies the previous editing, formatting, or layout change that you just removed with the Undo button.
✔ Touch/Mouse Mode (automatically added only to Excel running on touchscreen tablets and computers): Switches between the default mouse mode and touch mode, which puts more space between tabs and their command buttons to facilitate selection with a finger or stylus.
The Quick Access toolbar is very customizable because you can easily add any Ribbon command to it. Moreover, you’re not restricted to adding buttons for just the commands on the Ribbon; you can add any Excel command you want to the toolbar, even the obscure ones that don’t rate an appearance on any of its tabs. (See Book I, Chapter 2 for details on customizing the Quick Access toolbar.)
By default, the Quick Access toolbar appears right above the File Menu button and Ribbon tabs. To display the toolbar beneath the Ribbon above the Formula bar, click the Customize Quick Access Toolbar button (the drop-down button to the direct right of the toolbar with a horizontal bar above a down-pointing triangle) and then select Show Below the Ribbon from its drop-down menu. Doing this helps you avoid crowding out the name of the current workbook that appears to the toolbar’s right.
The Formula bar displays the cell address and the contents of the current cell. The address of this cell is determined by its column letter(s) followed immediately by the row number, as in cell A1, the very first cell of each worksheet at the intersection of column A and row 1, or cell XFD1048576, the very last of each Excel 2016 worksheet at the intersection of column XFD and row 1048576. The contents of the current cell are determined by the type of entry you make there: text or numbers, if you just enter a heading or particular value, and the nuts and bolts of a formula, if you enter a calculation there.
The Formula bar is divided into three sections:
✔ Name box: The leftmost section displays the address of the current cell address.
✔ Formula bar buttons: The second, middle section appears as a rather nondescript button displaying only an indented circle on the left (used to narrow or widen the Name box) with the Insert Function button (labeled fx) on the right until you start making or editing a cell entry. At that time, its Cancel (an X) and its Enter (a check mark) buttons appear in between them.
✔ Cell contents: The third white area to the immediate right of the Function Wizard button takes up the rest of the bar and expands as necessary to display really, really long cell entries that won’t fit in the normal area. This area contains a Formula Bar button on the far right that enables you to expand its display to show really long formulas that span more than a single row and then to contract the Cell contents area back to its normal single row.
The Cell contents section of the Formula bar is really important because it always shows you the contents of the cell even when the worksheet does not. (When you’re dealing with a formula, Excel displays only the calculated result in the cell in the worksheet and not the formula by which that result is derived.) You can edit the contents of the cell in this area at any time. By the same token, when the Cell contents area is blank, you know that the cell is empty as well.
Assigning 26 letters to 16,384 columns
When it comes to labeling the 16,384 columns of an Excel 2016 worksheet, СКАЧАТЬ