Advertisement
Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

How to Select Excel 2010 Commands with Keyboard Shortcuts

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.

1

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.

2

Press Alt.

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

3

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.

4

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.

5

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.

blog comments powered by Disqus
Advertisement
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win an iPad Mini. Enter to win now!