December 24, 2016
MS Excel Shortcut Keys That Mostly Used In Daily Office Work

MS Excel Shortcut Keys List
MS Excel is a best and also No.1 accounting software in the word. To quick done our job we use keyboard shortcuts in daily office work. Shortcut Keys is a best way to complete the job quickly and easily. So, here is a list of MS Excel Shortcut Keys that are used in our daily work.
MS Excel Shortcut Keys:
S/N | MS Excel Shortcut Keys | Shortcut Keys Description |
---|---|---|
1 | Ctrl + A | By pressing Ctrl + A we cab select all data of the worksheet. |
2 | Ctrl + B | Bold the selected text . |
3 | Ctrl + C | Copy the selected cell/data. |
4 | Ctrl + I | Italic the selected text. |
5 | Ctrl + K | You can insert Iink directly by pressing Ctrl +K. |
6 | Ctrl + S | Press these key to Save the open worksheet. |
7 | Ctrl + U | Underline selected text. |
8 | Ctrl + P | To get print dialog box/Print the documents. |
9 | Ctrl + Z | Press the Ctrl + Z button to Undo last action. |
10 | F2 | To Edit the selected cell. |
11 | F3 | F3 is a shortcut to paste names. |
12 | F4 | F4 is a best shortcut, It will change the text in cell to the same color and text font like last cell. |
13 | F5 | Press the F5 when you need to go to a specific cell Example: C6. |
14 | F7 | It is shortcut to run the spell check for selected text. |
15 | F11 | Create chart from selected document or dat . |
16 | Ctrl + ; | Insert the current date in the cell. |
18 | Ctrl + ~ | Switch between showing Excel formulas or their values in cells. |
19 | Ctrl + Home | Move to cell A1. |
20 | Ctrl + - | This is a quicker way to delete the selected column or row. |
21 | Ctrl + Space | Select entire column. |
22 | Ctrl + ' | With the help of this shortcut you can Insert the value of the above cell into the cell currently selected cell. |
23 | Ctrl + 1 | Quick way to change the format of selected cells. |
24 | Ctrl + 5 | Strike through selected data. |
25 | Ctrl + F3 | Quickly Open Excel Name Manager. |
26 | Ctrl + F9 | Minimize current window. |
27 | Ctrl + F10 | Maximize currently selected window. |
MS Excel Shortcut Keys That Are Used With Shift, Ctrl & ALT:
28 | Ctrl + Shift + 1 | Format number in comma -format. |
29 | Ctrl + Shift + 4 | Format number in currency-format. |
30 | Ctrl + Shift + 3 | Format number in date-format. |
31 | Ctrl + Shift + 5 | Format number in percentage-format. |
32 | Ctrl + Shift + 6 | Format number in scientific-format. |
33 | Ctrl + Shift + 2 | Format number in time-format. |
34 | Ctrl + Shift + = | Insert a new column/row. |
35 | Shift + Space | Select entire row. |
36 | Alt + = | Create a formula to sum all of the above cells. |
37 | Ctrl + Shift + ; | Insert the current time in the cell. |
38 | Alt + Enter | When you press the Alt + Enter It will move to the next line, allowing for multiple lines of text in one cell. |
39 | Alt + Shift + F1 | Make a new Worksheet. |
40 | Ctrl + Page up | Move between work sheets in the same document. |
By using above MS Excel Shortcut Keys you can do your office work very easily and on the time. In conclusion, Keyboard Shortcut a best way to do your job on time. Print these key and save into your memory.
