Excel 2010 Just the Steps For Dummies
Book image
Explore Book Buy On Amazon

Excel 2010, like the Office versions before it, has a lare number of built-in keyboard shortcuts that let you choose any Excel command without removing your fingers from the keyboard. The most common Excel commands have always had Ctrl-key shortcuts (such as Ctrl+S to Save), and those shortcuts still work. But now you can use keyboard shortcuts to access uncommon Excel commands.

Place the cell cursor in the proper location (if applicable).

For example, if you want to use the keyboard to apply formatting to specific cells, select those cells.

Press Alt.

Press Alt.

Shortcut letters appear on the Ribbon and numbers appear on the Quick Access toolbar.

Press a letter to select a tab on the Ribbon.

For example, press P to select the Page Layout tab. Excel displays the tab and letters for each command on that tab. For example, pressing P pulls up the Page Layout menu on the Ribbon.

Press a letter or letters to select a command.

Excel displays options for the command you selected. If you pressed the wrong key(s), you can press Esc to go back one step at a time.

Press a letter or use the arrow keys on the keyboard to select an option.

Press a letter or use the arrow keys on the keyboard to select an option.

Excel performs the command you selected, applying the option you chose.

About This Article

This article is from the book:

About the book author:

Diane Koers owns and operates All Business Service, a software training and consulting business formed in 1988, that services the central Indiana area. Her area of expertise has long been in the word-processing, spreadsheet, and graphics areas of computing. She also provides training and support for Peachtree Accounting Software. Diane's authoring experience includes over 40 books on topics, such as PC security, Microsoft Windows, Microsoft Office, Microsoft Works, WordPerfect, Paint Shop Pro, Lotus SmartSuite, Quicken, Microsoft Money, and Peachtree Accounting. Many of these titles have been translated into other languages, such as French, Dutch, Bulgarian, Spanish, and Greek. She has also developed and written numerous training manuals for her clients.
Diane and her husband enjoy spending their free time fishing, traveling, and playing with their four grandsons and their Yorkshire Terrier.

This article can be found in the category: