Microsoft Excel Keyboard Shortcuts: 20 Useful Shortcuts Jo Aapka Kaam Fast Bana Denge
Microsoft Excel ek powerful spreadsheet application hai, jiska use data ko organise, calculate, analyse aur present karne ke liye kiya jata hai. Office work se lekar accounting, business reports, data analysis aur personal calculations tak, Excel ka use bahut common hai.
Excel mein kaam karte waqt agar aap har chhote task ke liye mouse ka use karte hain, to kaam complete karne mein extra time lag sakta hai. Isi wajah se Excel keyboard shortcuts seekhna productivity improve karne ka ek simple tarika hai.
Keyboard shortcuts ki help se aap new worksheet insert karne, rows aur columns select karne, cells format karne, data search karne, formulas insert karne aur multiple workbooks ke beech switch karne jaise tasks ko quickly perform kar sakte hain.
Is guide mein hum 20 useful Microsoft Excel keyboard shortcuts ke baare mein jaanenge, jo beginners ke saath-saath regular Excel users ke liye bhi useful hain.
Excel Keyboard Shortcuts Use Karne Ke Benefits
Excel shortcuts seekhne ka sabse bada benefit hai ki aap repetitive tasks ko quickly perform kar sakte hain.
Keyboard shortcuts ki help se aap:
- Time save kar sakte hain
- Mouse par dependency kam kar sakte hain
- Repetitive tasks ko fast perform kar sakte hain
- Large spreadsheets mein efficiently navigate kar sakte hain
- Data entry aur formatting ka workflow improve kar sakte hain
Agar aap daily Excel par kaam karte hain, to kuch important shortcuts yaad karna aapki overall productivity ko kaafi improve kar sakta hai.
1. New Worksheet Insert Karne Ka Shortcut
Agar aap Excel workbook mein frequently new sheets add karte hain, to har baar bottom mein + button par click karne ki zarurat nahi hai.
Shortcut:
Shift + F11
Is shortcut ko press karte hi current workbook mein ek new worksheet insert ho jaati hai.
Ye shortcut particularly tab useful hai jab aapko ek workbook mein multiple worksheets quickly create karni hon.
2. Spreadsheet Mein Top Ya Bottom Par Quickly Move Karein
Large Excel spreadsheet mein manually scroll karke upar ya neeche jaana time-consuming ho sakta hai.
Shortcuts:
Ye shortcut large data tables ke saath kaam karte waqt kaafi useful hota hai.
3. Multiple Rows Ya Columns Insert Karein
Excel mein new rows ya columns add karne ke liye mouse se right-click karne ki zarurat nahi hai.
Shortcut:
Ctrl + +
Pehle required rows ya columns ko select karein aur phir shortcut use karein.
Agar aap multiple rows select karke shortcut use karte hain, to selected number of rows ke according new rows insert ki ja sakti hain.
4. Active Cell Ke Upar Ya Neeche Data Select Karein
Agar aapko current cell se upar ya neeche cells ka large block select karna hai, to mouse se drag karne ki zarurat nahi hai.
Shortcuts:
Large datasets ke saath kaam karte waqt ye shortcut especially useful hai.
5. Excel Cell Mein Comment Add Karein
Agar aap kisi cell ke saath additional information ya note add karna chahte hain, to comment/notes feature useful hota hai.
Shortcut:
Shift + F2
Isse selected cell mein note/comment add karne ka option open kiya ja sakta hai, depending on your Excel version.
6. Cell Ka Comment Delete Karein
Agar kisi cell mein pehle se added comment ya note ko remove karna hai, to keyboard shortcut ka use kar sakte hain.
Shortcut:
Shift + F10, phir D
Ye context menu open karke delete option select karne mein help karta hai. Excel ke different versions mein menu shortcut letter alag ho sakta hai.
7. Selected Cells Mein Upar Move Karein
Excel mein selected cells ke through quickly move karne ke liye Shift + Enter shortcut useful hai.
Shortcut:
Shift + Enter
Ye shortcut selected range mein active cell ko previous direction mein move karne mein help karta hai.
8. Excel Mein Format Cells Dialog Box Open Karein
Cell formatting ke liye baar-baar Ribbon mein options search karne ki zarurat nahi hai.
Shortcut:
Ctrl + 1
Isse Format Cells dialog box open hota hai.
Yahan se aap number format, alignment, font, border, fill aur protection jaise options customise kar sakte hain.
9. Last Action Repeat Karein
Excel mein kisi previous action ko repeat karne ke liye keyboard shortcuts ka use kiya ja sakta hai.
Shortcuts:
For example, agar aapne kisi cell par specific formatting apply ki hai, to F4 kai situations mein same action ko repeat karne mein help kar sakta hai.
10. Excel Mein Hyperlink Insert Karein
Kisi cell mein website, file ya other location ka link add karna ho, to shortcut se hyperlink dialog box open kar sakte hain.
Shortcut:
Ctrl + K
Cell select karke Ctrl + K press karein. Iske baad hyperlink insert karne ka option open ho jayega.
11. Entire Row Ya Column Select Karein
Excel mein complete row ya column select karne ke liye mouse se header par click karne ki zarurat nahi hai.
Shortcuts:
Ye shortcut formatting, deleting, copying ya moving rows/columns ke waqt kaafi useful hai.
12. Current Date Aur Time Insert Karein
Excel spreadsheet mein manually date aur time type karne ki zarurat nahi hai.
Shortcuts:
Ctrl + ; — Current date insert karein
Ctrl + Shift + ; — Current time insert karein
Ye shortcuts reports, attendance sheets, invoices aur daily records maintain karne mein useful ho sakte hain.
13. Excel Macros Open Karein
Agar aap Excel mein macros ka use karte hain, to Macro dialog box quickly open karne ke liye shortcut available hai.
Shortcut:
Alt + F8
Isse Macro dialog box open hota hai, jahan available macros ko run aur manage kiya ja sakta hai.
Macros repetitive Excel tasks ko automate karne mein useful hote hain.
14. Left Ya Right Data Select Karein
Large spreadsheet mein horizontally data select karne ke liye mouse se drag karne ki zarurat nahi hai.
Shortcuts:
Ctrl + Shift + → — Right side data select karein
Ctrl + Shift + ← — Left side data select karein
Ye shortcut large tables aur datasets mein quickly data select karne ke liye useful hai.
15. Excel Mein Rows Hide Karein
Agar spreadsheet mein kuch rows temporarily hide karni hain, to shortcut ka use kar sakte hain.
Shortcut:
Ctrl + 9
Pehle required row ya rows select karein aur Ctrl + 9 press karein.
Selected rows hide ho jayengi.
16. Excel Mein Function Insert Karein
Excel mein hundreds of functions available hain aur har function ka syntax yaad rakhna easy nahi hota.
Aise mein Insert Function option useful hota hai.
Shortcut:
Shift + F3
Isse Insert Function dialog box open kiya ja sakta hai.
Yahan se aap required function search karke select kar sakte hain.
17. Open Workbooks Ke Beech Switch Karein
Agar aap ek saath multiple Excel workbooks ke saath kaam kar rahe hain, to unke beech quickly switch karna useful hota hai.
Shortcut:
Ctrl + Tab
Isse open workbooks/windows ke beech switch karne mein help mil sakti hai.
Multiple files ke saath data compare karte waqt ye shortcut time save kar sakta hai.
18. Excel Mein Data Search Karein
Large spreadsheet mein manually kisi particular name, number ya word ko search karna difficult ho sakta hai.
Shortcut:
Ctrl + F
Isse Find option open hota hai.
Aap required text ya number enter karke spreadsheet mein uski location quickly find kar sakte hain.
Agar data ko replace karna hai, to Find and Replace feature ka use kiya ja sakta hai.
19. Currency Aur Percentage Format Apply Karein
Excel mein numbers ko quickly currency ya percentage format mein convert karne ke liye keyboard shortcuts available hain.
Currency Shortcut:
Ctrl + Shift + $
Percentage Shortcut:
Ctrl + Shift + %
For example, financial spreadsheet mein amount ko currency format aur calculation results ko percentage format mein quickly display karne ke liye ye shortcuts useful hain.
20. Extra Spaces Remove Karne Ke Liye TRIM Function
Excel mein imported ya copied data ke andar unwanted spaces aa sakte hain. Extra spaces ki wajah se sorting, matching aur data processing mein problems ho sakti hain.
Is problem ko fix karne ke liye TRIM function ka use kiya ja sakta hai.
Formula:
=TRIM(A1)
Yahan A1 us cell ko represent karta hai jisme text available hai.
TRIM function text ke beginning aur end ke unnecessary spaces ko remove karta hai aur words ke beech multiple spaces ko single space mein convert karne mein help karta hai.
Large datasets ko clean karte waqt ye function kaafi useful ho sakta hai.
Excel Shortcuts Seekhne Ka Best Tarika
Agar aap Excel mein beginner hain, to ek saath saare shortcuts yaad karne ki zarurat nahi hai.
Sabse pehle daily-use shortcuts se start karein, jaise:
In shortcuts ko daily use karne se dheere-dheere keyboard-based workflow ki habit develop ho sakti hai.
Conclusion
Microsoft Excel mein keyboard shortcuts seekhna productivity improve karne ka ek simple aur effective tarika hai. Ye shortcuts aapko repetitive mouse clicks ko reduce karne, spreadsheets mein quickly navigate karne aur common tasks ko faster complete karne mein help karte hain.
New worksheet insert karne se lekar rows aur columns select karne, cells format karne, hyperlinks add karne, data search karne aur TRIM function ke through extra spaces remove karne tak, ye shortcuts Excel workflow ko more efficient bana sakte hain.
Agar aap daily Excel use karte hain, to pehle kuch basic shortcuts yaad karein aur unhe apne regular work mein apply karein. Practice ke saath aapka Excel workflow faster aur more efficient ho jayega.
0 Comments
Do not enter any spam link in the comment box.