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 doesnt 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.