Category
Future Courses
Shortcut-Keys
Future Gadgets
Cheat Codes
Computer Tricks
Chat Room
MS-Excel ShortCut-Keys.
CTRL COMBINATIONS SHORT-CUT KEYS
| Effects | ShortCut |
|---|---|
|
Unhide any hidden rows within the selection. |
CTRL+SHIFT+( |
|
Unhide any hidden columns within the selection. |
CTRL+SHIFT+) |
| Applies the outline border to the selected cells |
CTRL+SHIFT+& |
|
Removes the outline border from the selected cells. |
CTRL+SHIFT_ |
|
Applies the General number format |
CTRL+SHIFT+~ |
|
Applies the Currency format with two decimal places |
CTRL+SHIFT+$ |
|
Applies the Percentage format with no decimal places . |
CTRL+SHIFT+% |
|
Applies the Exponential number format with two decimal places |
CTRL+SHIFT+^ |
|
Applies the Date format with the day, month, and year. |
CTRL+SHIFT+# |
|
Applies the Time format with the hour and minute, and AM or PM. |
CTRL+SHIFT+@ |
|
In a PivotTable, it selects the entire PivotTable report |
CTRL+SHIFT+* |
|
Enters the current time. |
CTRL+SHIFT+: |
|
Enters the current date |
CTRL+; |
|
Displays the Format Cells dialog box. |
CTRL+1 |
|
Applies or removes bold formatting. |
CTRL+2 |
|
Applies or removes italic formatting. |
CTRL+3 |
|
Applies or removes underlining. |
CTRL+4 |
|
Applies or removes strikethrough. |
CTRL+5 |
|
Alternates between hiding objects, displaying objects, |
CTRL+ 6 |
|
Displays or hides the outline symbols. |
CTRL+8 |
|
Hides the selected rows. |
CTRL+9 |
|
Hides the selected columns. |
CTRL+0 |
|
Applies or removes bold formatting. |
CTRL+B |
|
Copies the selected cells. |
CTRL+C |
| Displays the Go To dialog box. |
CTRL+G |
|
Creates a new, blank workbook. |
CTRL+N |
|
Displays the Open dialog box to open or find a file. |
CTRL+O |
|
Saves the active file with its current file name format. |
CTRL+S |
|
Displays the Create Table dialog box. |
CTRL+T |
|
Applies or removes underlining. |
CTRL+U |
|
Inserts the contents of the Clipboard at the insertion point |
CTRL+V |
|
Closes the selected workbook window. |
CTRL+W |
|
Cuts the selected cells. |
CTRL+X |
FUNCTION KEYS
| Effects | ShortCut |
|---|---|
| Displays the Microsoft Office Excel Helptask pane. | F1 |
| Edits the active cell and positions the insertion point | F2 |
| Adds or edits a cell comment. | SHIFT+F2 |
| Displays the Print Preview window. | CTRL+F2 |
| Displays the Paste Name dialog box. | F3 |
| Displays the Insert Function dialog box. | SHIFT+F3 |
| Repeats the last command or action, if possible. | F4 |
| Closes the selected workbook window. | CTRL+F4 |
| Displays the Go To dialog box. | F5 |
| Restores the window size of the selected workbook window. | CTRL+F5 |
| Switches between the worksheet, Ribbon, task pane, and Zoom controls | F6 |
| Displays the Spellingdialog box to check spelling | F7 |
| Turns extend mode on or off. In extend mode, Extended Selection | F8 |
| Displays the Macro dialog box to create, run, edit, or delete a macro. | ALT+F8 |
| Calculates all worksheets in all open workbooks. | F9 |
| Calculates the active worksheet. | SHIFT+F9 |
| Minimizes a workbook window to an icon. | CTRL+F9 |
| Turns key tips on or off. | F10 |
| Displays the shortcut menu for a selected item. | SHIFT+F10 |
| Displays the menu or message for a smart tag. | ALT+SHIFT+F10 |
| Maximizes or restores the selected workbook window | CTRL+F10 |
| Creates a chart of the data in the current range. | F11 |
| Inserts a new worksheet | SHIFT+F11 |
| Opens the Microsoft Visual Basic Editor | ALT+F11 |
| Displays the Save Asdialog box. | F12 |