Microsoft Office Tutorials and References
In Depth Information
Discovering Some Useful Shortcut Keys
Discovering Some Useful Shortcut Keys
Excel has no shortage of shortcut keys. Your productivity is sure to increase if you take the time
to learn the shortcut keys for commands that you use frequently. In the following table, I list
some of the most useful shortcut keys. This list is certainly not an exhaustive one — it describes
just the commands that I find most useful.
Shortcut
What You Can Do with It
F11
Create a new chart on a separate chart sheet (of the default chart type) by using
data in the selected range.
Alt+F1
Create a new, embedded chart (of the default chart type) by using the data in the
selected range.
F5
Display the Go To dialog box.
Alt
Display the keytips for the Ribbon commands so that you can access the
commands by using letters on the keyboard.
F2
Edit the active cell.
Shift+F2
Edit the comment in the active cell or insert a comment if the cell doesn’t have one.
Ctrl+Shift+_
Remove all borders from the selected cells.
Shift+F10
Display the shortcut menu for the selected item.
Ctrl+F6
Activate the next window.
Ctrl+PgUp
Activate the previous sheet in the workbook.
Ctrl+PgDn
Activate the next sheet in the workbook.
Alt+Ctrl+V
Display the Paste Special dialog box.
Alt+=
Perform the equivalent of clicking the AutoSum button.
Ctrl+B
Make the selected cells bold.
Ctrl+C
Copy the selected cells.
Ctrl+D
Copy the top cell in a selected range to the other cells in the selection.
Ctrl+F
Display the Find dialog box.
Ctrl+H
Display the Replace dialog box.
Ctrl+I
Make the selected cells italic.
Ctrl+N
Create a new default workbook.
Ctrl+R
Copy the leftmost cell in a selected range to the other cells in the selection.
Ctrl+S
Save the active workbook.
Ctrl+V
Paste a copied or cut item in the selected cell.
Ctrl+X
Cut the selected cells.
Ctrl+Y
Repeat the last repeatable command. If the last command was Undo, this shortcut
reverses the Undo.
Ctrl+Z
Undo the last action.
 
Search JabSto ::




Custom Search