Quamut. How to do it.
My Quamut   |  Help  |   Log In 
 
 

  1. House & Home
  2. Hobbies & Leisure
  3. Money & Business
  4. Computers & Technology
  5. Mind & Body
    Menu_purple_triangleAging & Retirement
    Menu_purple_triangleDiseases & Conditions
    Menu_purple_triangleFitness & Exercise
    Menu_purple_triangleHealth & Wellness
    Menu_purple_triangleMedical Reference
    Menu_purple_triangleMedications
    Menu_purple_triangleParenting
    Menu_purple_triangleSelf-Improvement
    Menu_purple_triangleSpirituality
powered by Barnes & Noble
 
 
   Excel 2007 found in Computers & Technology  :  Software  :  Microsoft A   A   A
text size
 
 
 
Add to my favorites Send this Quamut to a friend del.icio.us digg this Quamut
 

Keyboard Shortcuts in Excel 2007

Keyboard shortcuts are combinations of keystrokes that let you execute commands more quickly than with a mouse. Keyboard shortcuts from previous versions of Excel, such as Ctrl+S to save and Ctrl+B to bold, also work in Excel 2007.

This guide includes the Excel keyboard shortcuts associated with any commands covered in the guide, but it does not cover all of the hundreds of keyboard shortcuts that are possible in Excel. (For an organized quick reference of all of the keyboard shortcuts in Excel 2007, see the Quamut guide to Excel 2007: Keyboard Shortcuts.)

How to Customize Keyboard Shortcuts

You can create new shortcuts or modify existing shortcuts by recording actions as a macro. To record a macro:
  1. Click the Record Macro icon located at the bottom left of the Excel window.
  2. The Record Macro dialog box opens. Give the macro a name and assign it a shortcut key. The Store Macro In field should say Personal Macro Workbook. Click OK.
  3. Go to the View tab. At the far right, click the Macro drop-down menu and select Use Relative References.
  4. Do the action for which you’d like to make a shortcut.
  5. Click the Stop Record button at the bottom left of the main Excel window.
  6. To use the macro, press the shortcut key you assigned to it in step 2.

How to Control Excel Using the Keyboard

Along with keyboard shortcuts, Excel 2007 provides a keyboard system for executing most Excel commands. This system is based on the Alt key. Press the key and little letters and numbers appear next to the various tabs or commands on the screen. Hit the appropriate key (or keys) to use the marked command. For instance, to get to the Ribbon’s Home tab, you’d type Alt+H. Once there, a new set of letters and numbers appears that marks the Home tab commands. Hit those keys to enact those commands. To make the shortcut numbers and letters disappear, hit the Alt key again.

Alt-key commands can involve 2–5 keystrokes and may overlap with traditional keyboard shortcuts. For instance, you can save an Excel file using Ctrl+S or Alt+F, S.
 
 
  Acknowledgments & Disclaimer
 
 

 
 
 
Tags
 
No one has tagged this page yet... Be the first.. Log in using the link below and return to add your tag
 
Please Log In to Tag
 
 
Download & Print this Quamut to Go
 
Complete 6-page Quamut to Go PDF only $2.95
 
Excel 2007 Chart