Appendix A. USING EXCEL KEYBOARD SHORTCUTS

Using Excel Keyboard Shortcuts

You can execute Ribbon commands without taking your hands off the keyboard. This enables you to work quickly. This is particularly true if you are an excellent typist. The process is simple. You press the Alt key. Excel displays KeyTips — letters or numbers you can press to display more KeyTips or to execute a command. If a menu or dialog box appears after you press a KeyTip, use the arrow keys to move to your selection. Press the Enter key or the spacebar to make your selection.

For example, you can activate KeyTips to change the color of your type by clicking the keys shown in the KeyTip and then using the arrow keys to select the color you want. To cancel a KeyTips session, ...

Get Excel® Data Analysis: Your visual blueprint™ for creating and analyzing data, charts, and PivotTables, 3rd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.