Discover all the shortcuts with the Control Key
Follow these links to have others shortcuts with Excel,
Shortcut with figure
Warning: These shortcuts don't work with the keypad.
+ | Open the dialog box Cell Format |
+ | Toogle Bold |
+ | Toogle Italic |
+ | Toogle Underline |
+ | Toogle Strike through |
+ | |
+ | |
+ | Outline |
+ | Hide Row |
+ | Hide Column |
Shortcut with letter
+ |
|
+ | Toogle Bold |
+ | Copy |
+ |
|
+ | FlashFill |
+ | Open the dialog box Find |
+ | Open the dialog box Goto |
+ | Open the dialog box Replace |
+ | Toogle Italic |
+ | |
+ | Insert an Hyperlink |
+ | Create a table |
+ | |
+ | Open a new workbook |
+ | Open the dialog box Open a workbook |
+ | |
+ | |
+ | Fill Right |
+ | Save your workbook |
+ | Create a table (yes, one more time) |
+ | Toogle Underline |
+ | Paste |
+ | Close your workbook |
+ | Cut |
+ | Repeat action |
+ | Undo the last action |
Shortcut with symbol
+ | Select all the continous cells around the active cell |
+ | Return to the cell A1 |
+ | Return to the last cell known by Excel (and it's not necessarily the last cell of your array) |
+ | Goto the last non-empty cell of your column |
+ | Goto the first non-empty cell of your column |
+ | Goto the first non-empty cell of your row |
+ | Goto the last non-empty cell of your row |
+ | Copy the contain of the first row to the rest of your selection (more than 1 cell selected) |
+ | Copy the contain of the first column to the rest of your selection (more than 1 cell selected) |
+ | Toogle Formula mode |
+ | Insert the Date in your active cell |
+ | Insert the Time in your active cell |
+ | Format percentage |
+ | Delete selection |
+ | Insert selection |
+ | Applies the outline border to the selected cells |
+ | Removes the outline border from the selected cells |
+ | Unhides any hidden rows within the selection |
+ | Unhides any hidden columns within the selection |
+ | Applies the Date format with the day, month, and year |
+ | Applies the Exponential number format with two decimal places |
Shortcut with Function keys
+ | Hide / Unhide the Ribbon |
+ | View before Print |
+ | Define name |
+ | Close workbook |
+ | Restore Windows size |
+ | Toogle to the next workbook |
+ | Move Window (with the arrows) |
+ | Resize Window (with the arrows) |
+ | Minimize Workbook |
+ | Restore Workbook |
+ | Insert a Macro Excel 4 |
+ | Open the dialog box Open a Workbook |