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.


Written by Techorg

Leave a Reply

Your email address will not be published. Required fields are marked *

Tech Blogs in Nigeria

Top 10 Tech Blogs In Nigeria With Their Rankings

mozilla firefox

Mozilla Firefox Shortcut Keys – The Complete List