As we all know Microsoft Excel is one of the most popular spreadsheet and data analysis tool that comes with a lot of handy features ,That’s why today in this post I am going to cover all useful “Microsoft Excel keyboard shortcuts” for windows operating system that definitely helps you to perform different tasks in more easier and faster way.
So without wasting much more time ” Here is the list of most useful MS Excel keyboard shortcuts you should use.”
Keyboard Shortcuts For MS Excel
Keyboard Shortcuts | Description |
---|---|
Ctrl+O | To open a worksheet |
Ctrl+S | To save a worksheet |
Ctrl+B or Ctrl+2 | To make text bold |
Ctrl+I or Ctrl+3 | To make text Italic |
Ctrl+Z | To undo last executed command |
Ctrl+C | Copy |
Ctrl+V | Paste |
Ctrl+A | To select all the conent of a worksheet |
Delete key | To remove or erase specific cell content |
Ctrl+X | To move selected cells |
Ctrl+P | To open Print Dialog box for printing |
Ctrl+W | To close a worksheet |
Shift+F5 | To open "find" dialog box |
Alt+A | To open data tab |
Shift+Tab | Switch to previous tab in a worksheet |
Shift+F3 | To insert a function |
Ctrl+END | Move to the last cell of the spreadsheet |
Ctrl+F6 | To switch into next open workbook window |
Ctrl+Page up | Switch between worksheet tabs from left to right |
Shift+F11 | To insert a new worksheet |
Ctrl+Shift+: | To enter the current time |
Ctrl+; | Enter current date |
Ctrl+F9 | To minimze workbook window |
Ctrl+Spacebar | To select entire column |
Shift+Spacebar | To select entire row |
Ctrl+T or Ctrl+L | To display create table dialog box |
Alt+F8 | To Open Macro Dialog Box |
Ctrl+U or Ctrl+4 | To underline the text |
Ctrl+K | Insert Hyperlink |
Alt+H | Go to Home tab |
Ctrl+Pagedown | Move to the next sheet in a workbook |
Pageup | Move to the onescreen up in a workshee |
Pagedown | Move to the one screen down in the workbook |
Ctrl+Shift+Plus(+) | Inorder to insert blank cells by opning insert dialog box |
Shift+F9 | To calculate the active worksheet |
F7 | To check spelling by opening spelling dialog box |
Ctrl+Page Down | Switch between worksheet tab from right to left |
Ctrl+Shift+Pageup | Move to the previous sheet in a workbook |
Ctrl+Shift+Pagedown | Move to the next sheet in a workbook |
Ctrl+9 | To hide the selected rows |
Ctrl+0 | To hide the selected column |
Ctrl+F4 | To close the selected workbook window |
Alt+Enter | To insert a line break within cells |
Ctrl+(-) | To open delete dialog box |
F2 | Edit active cell |
Ctrl+Shift+H | To select the hyperlink |
Alt+= | To autosum a range of cells |
Ctrl+Shift+4 | Format as Currency |
Ctrl+Shift+1 | Format as Number |
Ctrl+Shift+# | Format as Date |
Ctrl+Shift+@ | Format as Time |
Ctrl+Shift+% | Format as percentage without decimal places |
Ctrl+Shift+^ | Format as exponential number format with two ecimal places |
F1 | To display excel help dialog box |
Also Read: Guide to use Paytm “Inbox” Chat Feature
If you have any query or suggestion regarding this post, then comment below, I tried my best to help you as soon as possible.
Like this post…..Don’t forget to share it with your friends on social media.