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 рдХрд░реЗрдВред рд╕рд╛рде рд╣реА рдПрдХ рдмрд╛рд░ рдХрд╛реЕрд▓ рдЬрд░реВрд░ рдХрд░ рд▓реЗрд╡реЗрдВред