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
Facebook
Share on twitter
Twitter
Share on whatsapp
WhatsApp
Share on pinterest
Pinterest
Share on linkedin
LinkedIn

This Post Has 8 Comments

  1. Milan Sharma

    Nice………………………………………………..:)

  2. Nehal Sharma

    thx
    nice blog

  3. Bhagyshree kumawat

    Nice…………………………….

  4. lata sharma

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

  5. Bhanu Priya kumawat

    Thanks

  6. Meena Nagda

    Thx for this blogs

  7. Indera Sharma

    good

Leave a Reply

Anil Computers

Anil Computers

Best computer Institute in Udaipur

Quiz_Anilcomputers1

सर्टिफिकेट  पाने के लिए अपने रिजल्ट का 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