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.
