Wednesday, January 30, 2019

MS Excel Most Useful Shortcuts in hindi



Dosto main aaj aapko MS Excel me kam aane wale bahot saare keyboard shortcuts ke bare me bataunga. jo apke work karne ke liye bahot hi important hogi ya phir koi interview me jane se pehle bahot hi upyogi saabit hogi. Aajkal ke samay me bina keyboard shortcuts se computer me koi bhi kaam ache se nai ho paata hai isliye aaj ke samay me sabhi ko keyboard shortcuts ke bare me aana bahot jaruri hogya hai. Chahe koi kaam ko jaldi karna ho ya koi interview dene jao to apko keyboard shortcuts ke puchha jata jo apko wo kaam karne aur interview ko crack karne me kafi useful saabit hota hai. Aaj ke samay me data entry ka kaam bahot saare jagaho par kiya jata hai. Agar waha kaam ka burden jyada ho to aap keyboard shortcuts ki madad se us kaam bahot hi kam samay me pura kar sakte hai aur aap boss ya apne sath kaam karne wale logo ke samne apna acha impression daal sakte hai. Ms excel me kuch bhi cheez ko entry karne ke liye aapko uske keyboard shortcuts ke bare me aana bahot jaruri hai. Agar apko MS Excel ke keyboard shortcuts ke bare pata nai hai to apko bahot hi pareshani ka samna karna pdega isliye aaj ke samay me data entry ke kaam ke liye aapko keyboard shortcuts ke bare basic knowledge to honi hi chahiye aur aap aapna kaam bahot hi kam samay me pura karne me safhal ho jayenge. To chahiye dosto shuru karte hai MS Excel ke shortcuts  ke bare me janane ke liye –

To sabse pehle hum apko MS Excel me use hone wale kuch shortcuts ke bare me batayenge jisme sabse pehla aata hai koi bhi MS Excel me worksheets ko navigate kaise karte hai –
NAVIGATE WORKSHEETS –
Arrow keys
Navigate by one cell at a time in any direction
Page down/Page up
Move one screen down/up
Alt+Page down/Page up
Move one screen right/left
Tab,/ Shift+Tab
Move one cell to the right / to the left in a worksheet
Ctrl + arrow keys
Move to the edge of next data region ( cells that contains data)
Home
Move to the beginning of row
Ctrl + Home
Move to the beginning of worksheet
Ctrl + End
Move to the last cell with content of worksheet
Ctrl + G
Display the goto dialog box
Ctrl + G the type e.g. A50
Go to line 50, Column A
Ctrl + G then type e.g. G1
Go to Column G, line 1


Agar aapko humara post acha laga ho to hume daily follow kare aur bahot jyada share kare. Jisse hume aapke liye aisi hi badiya badiya article post karte rahenge jo aapke liye future me bahot helpful saabit hogi. to agle post me hum isse aage ke shortcuts ke bare me aapko bateyenge jo aapke liye helpful saabit hogi.
Follow us on Blog Duniya

Disqus Comments