List of all Microsoft Excel Shortcut Keys

microsoft excel

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.


Previous articleDifference Between Apple, iPhone And iOS
Next articleMozilla Firefox Shortcut Keys – The Complete List
We are a group of niche-specialized writers. We research for first class information and report it on Most of the articles we display here are on business, technology, investment, banking and any other information we expect to be relevant to this blog.

Leave a reply

Please enter your comment!
Please enter your name here