Keyboard Shortcuts – Part 1

Here are the steps to follow in this lesson:

  1. All shortcuts in this lesson require you to hold down the “CTRL” key while you press a single Letter.
  2. Ctrl+A will select either all of the cells in the current worksheet or just the range of cells where you are working.
  3. Ctrl+B (Bold), Ctrl+I (Italic) and Ctrl+U (Underline) will “toggle” the formatting on or off.
  4. Ctrl+D (Fill Down) and Ctrl+R (Fill Right) require you to select a range of cells beforehand.
  5. 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)
  6. 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.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

rss Subscribe to our RSS Feed

4 Responses to “Keyboard Shortcuts – Part 1”

  1. The Company Rocks Excels » Blog Archive » Select Excel Data w/ Keyboard & Mouse-click Shortcuts Says:

    [...] Excel Keyboard Shortcuts – Part 1 [...]

  2. The Company Rocks Excels » Blog Archive » My Favorite Excel Keyboard Shortcut Says:

    [...] Excel Keyboard Shortcuts Part 1 [...]

  3. The Company Rocks Excels » Blog Archive » Keyboard Shortcuts - Part 2 - The Function Keys Says:

    [...] Keyboard Shortcuts – Part 1Keyboard Shortcuts – Part 1 [...]

  4. The Company Rocks Excels » Blog Archive » Most popular Excel Video Lessons in July 2008 Says:

    [...] Keyboard Shortcuts – Part 1 [...]

Leave a Reply


Powered by WishList Member - Membership Site Software