Excel Megic: Mastering 4 Important Settings for Efficient Data Management
1.Gridline color change karna: Excel mein gridlines kaafi important hota hai kyunki ye aapke sheet ko organized aur readable banata hai. Aap gridline ka color easily change kar sakte hai. Iske liye aapko "Page Layout" tab mein jana hoga, wahan se "Gridlines" option par click karna hoga, aur phir "More Gridlines" option ko select karna hoga. Yahan se aap apne hisaab se gridline ka color select kar sakte hai.
2.Enter down na ja kar apne according jana: Excel mein by default, jab aap ek cell mein data enter karte hai, toh next cell mein jana ke liye aapko Enter key press karna hota hai. Lekin agar aap chahte hai ki Enter key press karne ke bajaye aapka cursor apne hisaab se niche ki taraf jaye, toh iske liye aapko "File" tab mein jana hoga, phir "Options" par click karna hoga, aur "Advanced" option mein scroll down karte huye "After pressing Enter, move selection" option ko select karna hoga, aur "Down" option ko choose karna hoga.
3.Column me jo alphabet hote hai use number me change karna: Excel mein har column ko ek unique number se represent kiya jata hai. Lekin agar aap chahte hai ki column alphabet ko number mein convert karna, toh iske liye aapko "File" tab mein jana hoga, phir "Options" par click karna hoga, aur "Formulas" option mein scroll down karte huye "R1C1 reference style" option ko select karna hoga. Ab aapke sheet mein sabhi column alphabet se number mein convert ho jayenge.
4.Row, column ki position ko change karna: Excel mein aap row aur column ki position easily change kar sakte hai. Iske liye aapko pehle cell ko select karna hoga jise aap move karna chahte hai. Phir aapko mouse pointer ko cell ke border par le jana hoga, aur phir aapko pointer ko drag karke nayi position par le jana hoga. Aap is process ko row aur column dono ke liye apply kar sakte hai.
#exceltips
#excelsettings
#excelgridlines
#excelnavigation
#excelcolumns
#excelrows
#excelalphabettonumber
#excelpositionchange
#exceltutorial
#excelhow-to
.
.
.
.
.
.
.
#exceltutorialinhindi
#exceltutorialforbeginners
#excel#microsoftexcelexcel
#excelinhindihindi
#excelinhinditutorial
#excelhinditutorial
#microsoftexcel
#excelbyeducatepoint
#exceltutorials
#Completemicrosoftexceltutorial
#excel2019 #excel2020
#excelinhindifullcourse
#excelforbeginners2020
#excelfullcoursehindi
#educatepoint
#learnexcelinhindi
#exceltips2020
#exceltutorialforbeginnersinhindi
Connect with Educate Point on social media for the latest Video, promos, and much more:
► Subscribe: https://www.youtube.com/channel/UCqfI...
► Facebook: https://www.facebook.com/profile.php?...
► Instagram: / educate_point
-----------------------------------| Thanks |------------------------
#microsoftexcel #excel #excelshortcutsinhindi