
This post contains the full complete of Microsoft Excel shortcut you should know to increase your speed and accuracy while making use of it.
Microsoft Excel is a spreadsheet tool that comes with the Microsoft Office suite. The software is broadly used in the world by most offices and organization.
The features and functions that come with Excel are so versatile that it can be used to do most any usual office work.
Those who have gone deep in excel can use to tool to build lite app such as payroll computation.
The mathematical functionalities that make the software are capable of solving almost any kind of mathematical equation in just a few steps.
To save time, the Excel tool has some shortcuts that can help users to perform task faster than expected. We are giving the list of Excel shortcuts you should always have on your fingertips.
Microsoft Excel Shortcut Keys
No | Keys | Functions |
1 | F2 | Edit the selected cell |
2 | F5 | Go to a specific cell |
3 | F11 | Create a chart |
4 | Ctrl + Shift + | Enter the current time |
5 | Ctrl + | Enter the current date |
6 | Alt + Shift + F1 | Insert New Worksheet |
7 | Shift + F3 | Open the Excel formula window |
8 | Shift + F5 | Bring up search box |
9 | Ctrl + A | Select all contents of the worksheet |
10 | Ctrl + B | Bold highlighted selection |
11 | Ctrl + I | Italic highlighted selection |
12 | Ctrl + K | Insert link |
13 | Ctrl + U | Underline highlighted selection |
14 | Ctrl + 5 | Strike-through highlighted selection |
15 | Ctrl + P | Bring up the print box to begin printing |
16 | Ctrl + Z | Undo the last action |
17 | Ctrl + F9 | Minimize current window |
18 | Ctrl + F10 | Maximize currently selected window |
19 | Ctrl + F6 | Switch between open workbooks/windows |
20 | Ctrl + Page up | Move between Excel worksheets in the same Excel document |
21 | Ctrl + Page down | Move between Excel worksheets in the same Excel document |
22 | Ctrl + Tab | Move between Two or more Excel files that are open |
23 | Alt + = | Create a formula to add all of the above cells |
24 | Ctrl + | Insert the value of the above cell into cell currently selected |
25 | Ctrl + Shift + ! | Format number in comma format |
26 | Ctrl + Shift + $ | Format number in currency format |
27 | Ctrl + Shift + # | Format number in date format |
28 | Ctrl + Shift + % | Format number in a percentage format |
29 | Ctrl + Shift + ^ | Format number in scientific format |
30 | Ctrl + Shift + @ | Format number in time format |
31 | Ctrl + Arrow key | Move to next section of text |
32 | Ctrl + Space | Select entire column |
33 | Shift + Space | Select entire row |
Related Tags: shortcut keys in excel | ms word and excel shortcut keys | excel shortcut keys list | 20 shortcut keys of ms excel |excel shortcuts formulas | ms excel shortcut keys | excel shortcut keys chart | 50 shortcut keys of ms excel.
RELATED ARTICLES