Excel Function Key level 1

Table of Contents

S.No Shortcut key  Microsoft Excel
1 Ctrl + Shift + & Place outline border arow selected cells
2 Ctrl + Shift + – Remove outline border
3 Ctrl + Shift + + Insert ( Row, Columns or cell )
4 Ctrl+- Delete.
5 Ctrl + Shift + ~ General Number Formate
6 Ctrl + shift   + ! Two decimal places , thousands Saparator ex – 16618  Change 16, 618.
7 Ctrl + Shift + $ Currency Format with two decimal places
8 Ctrl + Shift + % Percentage format with No decimal places ( Apply Blank cell )
9 Ctrl + Shift + ^ Scientific not action number Format with Two decimal
10 Alt + Ctrl + V paste Special Box
11 Ctrl + Alt + V + T Paste Format Only
12 Alt + W + F (Un) Freeze Window
13 Alt+W+Q Change Zoom Size
14 Alt+H+O+R Change tab name
15 Alt+H+A Align
16 Window+D Minimize program
17 Window+E window explorer
18 Ctrl+` Change the columns size in a worksheet
19 Ctrl+’ Copies a formula from the cell above
20 Ctrl+Shift+P Opens the drop-down menu for point size.
21 Shift+Insert Pastes what is stored on the clipboard.
22 Shift+Page Up In a single column, highlights all cells above that which are selected.
23 Shift+Page Down In a single column, highlights all cells above that which are selected.
24 Shift+Home Highlights all text to the left of the cursor.
25 Shift+Up Arrow Extends the highlighted area up one cell.
26 Shift+Down Arrow Extends the highlighted area down one cell.
27 Shift+Left Arrow Extends the highlighted area left one character
28 Shift +Right Arrow Extends the highlighted area right one character
29 Alt+Spacebar Opens the system menu
30 Alt+Backpspace Undo

Share with your friends

Share on facebook
Share on twitter
Share on whatsapp
Share on pinterest
Share on linkedin

This Post Has 8 Comments

  1. Milan Sharma


  2. Nehal Sharma

    nice blog

  3. Bhagyshree kumawat


  4. lata sharma

    Good……………………………. 🙂

  5. Bhanu Priya kumawat


  6. Meena Nagda

    Thx for this blogs

  7. Indera Sharma


Leave a Reply

Anil Computers

Anil Computers

Best computer Institute in Udaipur


सर्टिफिकेट  पाने के लिए अपने रिजल्ट का Screen shot नीचे दिये गये मोबाइल नम्बर पर send करें। साथ ही एक बार काॅल जरूर कर लेवें।

Notice: Undefined index: force_wall in /home/waapsols/public_html/anilcomputersudaipur/wp-content/plugins/ocean-extra/includes/widgets/facebook.php on line 155