Appendix A. Excel Shortcut Keys
Throughout this book, I’ve introduced you to a host of Excel shortcut keys. As you have learned, Excel shortcut keys allow you to perform certain tasks using only the keyboard, which limits the number of instances your hands have to move back and forth from the keyboard to the mouse thereby saving you precious time. Getting in the habit of using these shortcut keys can help you work more efficiently and become more productive.
Using the Excel Shortcut Key Reference Table
The table included here lists the keyboard shortcuts I have covered during this book, and many more that you have not yet seen. You can use this appendix as an ongoing reference of the more commonly used Excel shortcut keys.
The Key column lists the root key on the keyboard you need to press. The Alone column tells you what task is triggered if the root key is pressed by itself. Some keys like the F1 key trigger a task when pressed alone, while others (like the letter A) do not cause Excel to take any action.
The Shift column tells you what task is triggered if the root key is pressed with the Shift key. For example the F5 key pressed in conjunction with the Shift key (Shift+F5) activates the Find dialog box.
The Ctrl column tells you what task is triggered if the root key is pressed with the Ctrl key. For example the B key pressed in conjunction with the Ctrl key (Ctrl+B) applies the Bold font to selected text.
The Alt column tells you what task is triggered if the root key is pressed with the Alt key. For example the F4 key pressed in conjunction with the Alt key (Alt+F4) closes Excel.
The Ctrl+Shift column tells you what task is triggered if the root key is pressed with the Ctrl and the Shift keys together. For example the F12 key pressed in conjunction with the Ctrl and Shift keys (Ctrl+Shift+F12) prints the active workbook.
