Here are the steps to follow in this lesson:
- All shortcuts in this lesson require you to hold down the “CTRL” key while you press a single Letter.
- Ctrl+A will select either all of the cells in the current worksheet or just the range of cells where you are working.
- Ctrl+B (Bold), Ctrl+I (Italic) and Ctrl+U (Underline) will “toggle” the formatting on or off.
- Ctrl+D (Fill Down) and Ctrl+R (Fill Right) require you to select a range of cells beforehand.
- The “Office Clipboard” allows you to retain 24 items in memory. You can use them in all of the applications across the MS Office Suite. (Ctrl+F1 brings up the Task Pane for the Clipboard)
- Ctrl+Z (Undo) and Ctrl+Y (Redo) apply to the last 16 actions (provided you have not “saved” the workbook.)
Find the video lesson that you want – Index to all Excel Topics
News! My DVD, “The 50 Best Tips for Excel 2007” is now available to purchase. I invite you to visit my online bookstore for more details.
Link to this post!
[…] Excel Keyboard Shortcuts – Part 1 […]