Preparing a lengthy sheet in MS Excel and then revising the data or editing any single piece of information in the complete sheet would be time-consuming of you are not aware of the shortcut keys for MS Excel. All computer keyboard shortcut keys for MS office programs have been discussed below. Check out the table given below to know the shortcut keys used in MS Excel.
Shortcut keys | Used of shortcut keys |
Alt + Shift + F1 | When you want insert new worksheet use these keys together |
Shift + F3 | With the help of these keys, you can open the MS-Excel formula window |
Shift + F5 | when you press these keys together it will open the search box |
F11 | The F11 key is used to create a chart in MS excel |
Ctrl + shirt +; | With the help of these keys, you can enter the current time |
Ctrl +; | Use these keys together to enter the current date |
Ctrl + K | When you want to insert a link, you can use these keys together |
Ctrl + F | These keys are used to open find and replace options in MS-Excel |
Ctrl + G | Use these keys together to open go-to options |
Ctrl + B | When you press these keys together it will bold highlighted selection |
F2 | When you want to edit the selected cell using this key |
F5 | With the help of this key, you can go to a specific cell |
F7 | With the help of this key, you can check the spell of selected text |
Ctrl + I | These commands are used to Italicize highlighted selection. |
Ctrl + space | Use these keys together to select the entire column |
Shift + space | Use these keys together to select the entire now |
Ctrl + W | Use these keys together to close the document |
Ctrl + H | Use these keys to open find and replace options |
Ctrl + U | With help of these keys, you can underline highlighted text |
Ctrl + Y | With help of these keys, you can underline highlighted text |
Ctrl + Z | With the help of these keys, you can undo the last deleted action |
Ctrl + F9 | Use these keys to minimize a current window in MS- Excel |
Ctrl + F10 | Use these keys to maximize the currently selected window in MS- Excel |
Ctrl + Tab | With the help of these keys, you can move between two or more open MS-Excel |
Ctrl + = | With the help of these keys, you can initiate the formula to add all of the above cells |
Ctrl + | With this of these keys together you can insert the value in the current cell from the above cell. |
Ctrl (right arrow) | With the help of these keys, you can jump on to the next section of text |
Ctrl + O | Use these keys to open options in MS-Excel |
Ctrl + N | Use these keys together to open the document in MS- Excel |
Ctrl + P | Use these keys together to open print dialogue box in MS Excel |
Post a Comment