List of all Microsoft Excel Shortcut Keys

List of all Microsoft Excel Shortcut Keys
(Last Updated On: October 9, 2017)

Microsoft Excel Shortcut | Keyboard Shortcuts | Accessibility Shortcuts | Microsoft Shortcuts | Typing Shortcuts | Laptop Shortcuts | Computer Shortcuts

This post contains a full complete of Microsoft Excel shortcut you should know to increase your speed and accuracy while making use of it.

Today’s word is currently controlled by ICT, with technology you can do virtually everything. With  speed and accuracy definitely the sky will be the limit.

Microsoft Excel Shortcut Keys

No

Keys

Functions

1 F2 Edit the selected cell
2 F5 Go to a specific cell
3 F11 Create 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 Strikethrough highlighted selection
15 Ctrl + P Bring up the print dialog box to begin printing
16 Ctrl + Z Undo 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 work sheets in the same Excel document
21 Ctrl + Page down Move between Excel work sheets in the same Excel document
22 Ctrl + Tab Move between Two or more open Excel files
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 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

Other Important shortcuts

Related posts

Leave a Reply

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

error: Naijatechzone.com !!