Excel Function Key level 2

Table of Contents

S.No Shortcut key  Microsoft Excel
1 Ctrl + 1  Open The Format Cells Dialog box
2 Ctrl + 2  Bold 
3 Ctrl + 3 Italic 
4 Ctrl + 4  Underline
5 Ctrl + 5 Stricke through 
6 Ctrl + 6  Show /Hide objects
7 Ctrl +  9  Hide row
8 Ctrl + Shift + 9  unhide row 
9 Ctrl + 0  Hide Column 
10 Ctrl + Shift + 0 Unhide Column 
11 Ctrl + ~ Increase Column Width 
12 Ctrl + Pgdown  Switch to the next worksheet 
13 Ctrl + Page Up  Switch to the previous Sheet 
14 Home Return to the 1 st cell of the Current row in a worksheet.
15 Ctrl + Home  Move to the beginning of a worksheet ( A1 Cell )
16 Ctrl + End  Move to the last used cell of the current worksheet
17 Ctrl + Space  Select entier Column 
18 Shift + Space  Select entire 
19 Ctrl + – Delete (Rows, Columns or cells )
20 Ctrl + ;  Insert Current Date 
21 Ctrl + shift + : insert Currrent time 
22 Alt + Enter  In cell editing mode, enter a new lime.
23 Ctrl + Shift + Home Select entire range of cells from  end to start 
24 Ctrl + shift + End Select entire range of cells from Start to end .
25 Ctrl + Shift + “ Copy Value From cell Above 

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 14 Comments

  1. Sunil Jain

    Informative Blog. Thanks

  2. Payal Tak

    Good Task.

  3. Santosh Saini

    Thank You Sir

  4. aasima khan

    Good Information

  5. Milan Sharma

    Good Very Nice Information

  6. Nehal Sharma

    thx
    nice blog

  7. Bhagyashree Kumawat

    Thx

  8. lata sharma

    Good.

  9. Bhanu Priya kumawat

    Thanks

  10. Bhanu priya kumawat

    Thx

  11. Neeilma jain

    very helpful

  12. Meena Nagda

    very nice………..

  13. 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