Important Short Keys For MS Excel.
Get Important Short keys for Microsoft Excel. Here you can also find all almost all important short keys that are being use in MS-Excel for different functionality. Get MS-EXCEL Short Keys to get better understanding and smooth working with Microsoft Excel. Here you can also find important short keys for MS-Word and MS-Power Point.
List Of Important Short Keys For MS Excel.
Short Keys | Actions |
Ctrl+A | Select All |
Ctrl+B | Bold |
Ctrl+C | Copy |
Ctrl+D | Fill Down |
Ctrl+F | Find |
Ctrl+G | Goto |
Ctrl+H | Replace |
Ctrl+I | Italic |
Ctrl+K | Insert Hyperlink |
Ctrl+N | New Workbook |
Ctrl+O | Open |
Ctrl+P | |
Ctrl+R | Fill Right |
Ctrl+S | Save |
Ctrl+U | Underline |
Ctrl+V | Paste |
Ctrl W | Close |
Ctrl+X | Cut |
Ctrl+Y | Repeat |
Ctrl+Z | Undo |
F1 | Help |
F2 | Edit |
F3 | Paste Name |
F4 | Repeat last action |
F4 | While typing a formula, switch between absolute |
F5 | Goto |
F6 | Next Pane |
F7 | Spell check |
F8 | Extend mode |
F9 | Recalculate all workbooks |
F10 | Activate Menubar |
F11 | New Chart |
F12 | Save As |
Ctrl+: | Insert Current Time |
Ctrl+; | Insert Current Date |
Ctrl+” | Copy Value from Cell Above |
Ctrl+’ | Copy Formula from Cell Above |
Shift+F1 | What’s This? |
Shift+F2 | Edit cell comment |
Shift+F3 | Paste function into formula |
Shift+F4 | Find Next |
Shift+F5 | Find |
Shift+F6 | Previous Pane |
Shift+F8 | Add to selection |
Shift+F9 | Calculate active worksheet |
Shift+F10 | Display shortcut menu |
Shift+F11 | New worksheet |
Shift+F12 | Save |
Ctrl+F3 | Define name |
Ctrl+F4 | Close |
Ctrl+F5 | xL, Restore window size |
Ctrl+F6 | Next workbook window |
Shift+Ctrl+F6 | Previous workbook window |
Ctrl+F7 | Move window |
Ctrl+F8 | Resize window |
Ctrl+F9 | Minimize workbook |
Ctrl+F10 | Maximize or restore window |
Ctrl+F11 | Inset Macro sheet |
Ctrl+F1 | File Open |
Alt+F1 | Insert Chart |
Alt+F2 | Save As |
Alt+F4 | Exit |
Alt+F8 | Macro dialog box |
Alt+F11 | Visual Basic Editor |
Ctrl+Shift+F3 | Create name by using names of row and colum labels |
Ctrl+Shift+F6 | Previous Window |
Ctrl+Shift+F12 | |
Alt+Shift+F1 | New worksheet |
Alt+Shift+F2 | Save |
Alt+= | AutoSum |
Ctrl+` | Toggle Value/Formula display |
Ctrl+Shift+A | Insert argument names into formula |
Alt+Down arrow | Display AutoComplete list |
Alt+’ | Format Style dialog box |
Ctrl+Shift+~ | General format |
Ctrl+Shift+! | Comma format |
Ctrl+Shift+@ | Time format |