| 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 |
Excel Function Key level 2
Table of Contents
Share with your friends
Share on facebook
Facebook
Share on twitter
Twitter
Share on whatsapp
WhatsApp
Share on pinterest
Pinterest
Share on linkedin
LinkedIn
Anil Computers
Best computer Institute in Udaipur
सर्टिफिकेट पाने के लिए अपने रिजल्ट का Screen shot नीचे दिये गये मोबाइल नम्बर पर send करें। साथ ही एक बार काॅल जरूर कर लेवें।
- 9414234600
Previous
Next
This Post Has 14 Comments
Informative Blog. Thanks
Thanks
Good Task.
Thank You Sir
Good Information
Good Very Nice Information
thx
nice blog
Thx
Good.
Thanks
Thx
very helpful
very nice………..
good