Shortcut Keys Used in MS Excel

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.ActivityShortcut Keys
1To Insert Current TimeCtrl + :
2To Insert Current DateCtrl + ;
3To Copy Value From Cell AboveCtrl + “
4To Copy Value From the Cell AboveCtrl + ‘
5To Convert Number into Exponential FormatCtrl + Shift  + ^
6To Open the Find WindowCtrl + Shift + &
7For Cell formattingCtrl + Shift +F
8To Remove Outline bordersCtrl + Shift +_
9To Insert Rows and ColumnsCtrl + +
10To Delete Rows & ColumnsCtrl + –
11To Auto sumAlt + =
12To Display Auto-Complete ListAlt + Down Arrow
13To Select AllCtrl + A
14To Bold the textCtrl + B
15To CopyCtrl + C
16To Open the Find WindowCtrl + F
17To open a Go to Window Ctrl + G
18To open Find and Replace WindowCtrl + H
19To Open the New WindowCtrl + N
20To Open the Print WindowCtrl + P
21To Save the WorkCtrl + S
22To Underline the Selected TextCtrl + U
23To PasteCtrl + V
24To CutCtrl + X
25To RedoCtrl + Y
26To UndoCtrl + Z
urUrdu