Excel is a powerful tool of Microsoft Office and is very popular because it is very user-friendly. In every field, excel is used for data management, data collection, and sorting. Simple programming and tools are developed easily using Microsoft Excel. Excel simplifies our calculation with accuracy and minimizes the time taken. In this article, some short keys of Excel are listed, which are frequently used. You memorize these shortcut keys below and save your time. BECAUSE TIME IS MONEY
S. No. | Activity | Shortcut Keys |
1 | To Insert Current Time | Ctrl + : |
2 | To Insert Current Date | Ctrl + ; |
3 | To Copy Value From Cell Above | Ctrl + “ |
4 | To Copy Value From the Cell Above | Ctrl + ‘ |
5 | To Convert Number into Exponential Format | Ctrl + Shift + ^ |
6 | To Open the Find Window | Ctrl + Shift + & |
7 | For Cell formatting | Ctrl + Shift +F |
8 | To Remove Outline borders | Ctrl + Shift +_ |
9 | To Insert Rows and Columns | Ctrl + + |
10 | To Delete Rows & Columns | Ctrl + – |
11 | To Auto sum | Alt + = |
12 | To Display Auto-Complete List | Alt + Down Arrow |
13 | To Select All | Ctrl + A |
14 | To Bold the text | Ctrl + B |
15 | To Copy | Ctrl + C |
16 | To Open the Find Window | Ctrl + F |
17 | To open a Go to Window | Ctrl + G |
18 | To open Find and Replace Window | Ctrl + H |
19 | To Open the New Window | Ctrl + N |
20 | To Open the Print Window | Ctrl + P |
21 | To Save the Work | Ctrl + S |
22 | To Underline the Selected Text | Ctrl + U |
23 | To Paste | Ctrl + V |
24 | To Cut | Ctrl + X |
25 | To Redo | Ctrl + Y |
26 | To Undo | Ctrl + Z |