20 Excel Tricks in Hindi: Beginners Se Expert Banne Ki Complete Guide

Microsoft Excel duniya ka sabse popular spreadsheet software hai. Chahe aap student ho, office employee, accountant ya business owner, Excel ka basic knowledge aaj ke time mein bahut zaroori hai.

Microsoft ne Excel 2010 aur uske baad ke versions mein kai powerful features add kiye hain, jisse bade se bade data ko manage karna bahut aasaan ho gaya hai. Lekin bahut se users sirf basic functions hi use karte hain aur Excel ki kai hidden tricks ko ignore kar dete hain.

🔔 Don't miss our latest updates!
Tap the bell icon at the top of this channel to turn on notifications.

Is article mein hum 20 aise Excel tricks aur shortcuts ke baare mein jaanenge jo aapki productivity ko kaafi improve kar sakte hain. Ye tricks beginners aur advanced users dono ke liye useful hain.

Note: Is article mein diye gaye examples Microsoft Excel 2010 par based hain, lekin inmein se adhiktar tricks Excel 2013, 2016, 2019, 2021 aur Microsoft 365 mein bhi kaam karti hain.

Technology Category Tips

1. Sirf Ek Click Mein Puri Worksheet Select Karein

Agar aap puri worksheet ka data select karna chahte hain, to aksar Ctrl + A shortcut use kiya jata hai.

Lekin ek aur bhi fast tareeka hai.

Worksheet ke top-left corner mein, row numbers aur column letters ke beech jo chhota square button hota hai, us par sirf ek baar click karein.

Isse puri worksheet turant select ho jayegi.

Microsoft Excel Official Website

2. Ek Saath Multiple Excel Files Open Karein

Agar aapko ek hi time par kai Excel files open karni hain, to unhe ek-ek karke open karne ki zarurat nahi hai.

Kaise karein?

1. Jitni Excel files open karni hain un sabhi ko select karein.
2. Ab keyboard par Enter press karein.

Sabhi selected Excel files ek saath open ho jayengi.

Ye trick tab bahut useful hoti hai jab aapko multiple reports compare karni hoti hain.

3. Multiple Excel Files Ke Beech Jaldi Switch Karein

Kai baar ek hi time par 4–5 Excel files open hoti hain. Mouse se baar-baar switch karna time waste karta hai.

Iske liye keyboard shortcut use karein.

Shortcut

Ctrl + Tab

Is shortcut ki madad se aap ek open Excel workbook se doosri workbook mein instantly switch kar sakte hain.

Ye shortcut kai dusre software jaise web browsers mein bhi kaam karta hai.

Ye Bhi Padhein

PDF File se Password Kaise Remove Karein

PDF File se Password Kaise Remove Karein

4. Quick Access Toolbar Mein Apne Favourite Shortcuts Add Karein

Default Excel mein Quick Access Toolbar par sirf kuch buttons hote hain jaise:

• Save
• Undo
• Redo

Agar aap Copy, Cut, Paste ya koi aur command frequently use karte hain, to unhe bhi toolbar mein add kar sakte hain.

Steps

1. File par click karein.
2. Options open karein.
3. Quick Access Toolbar select karein.
4. Left side list se Cut, Copy, Paste ya koi bhi command choose karein.
5. Add button par click karein.
6. OK dabayein.

Ab ye shortcuts hamesha top toolbar mein available rahenge.

Image: (Existing image same rakhein)

5. Excel Cell Mein Diagonal Line Kaise Add Karein

Kabhi-kabhi table banate waqt pehle cell mein Diagonal Line ki zarurat padti hai.

Jaise:

• Student Name
• Subject
• Address List
• Attendance Sheet

Diagonal Border Add Karne Ka Tareeka

1. Cell select karein.
2. Home → Borders → More Borders par jaayein.
3. Border options mein Diagonal Line icon select karein.
4. OK par click karein.

Ab selected cell mein diagonal line add ho jayegi.

Image: (Existing image same rakhein)

6. Ek Saath Multiple Rows Ya Columns Insert Karein

Bahut se log ek-ek row insert karte hain, jisme kaafi time lagta hai.

Agar aapko ek saath 5 ya 10 rows insert karni hain to ye trick use karein.

Example

Agar aapko 5 rows insert karni hain:

1. Pehle 5 rows select karein.
2. Right-click karein.
3. Insert choose karein.

Excel automatically utni hi rows insert kar dega jitni rows aapne select ki thi.

Ye trick columns ke liye bhi bilkul isi tarah kaam karti hai.

7. Cells Ko Fast Move Aur Copy Karein

Excel mein data ko Cut-Paste karna zaroori nahi hota.

Aap drag-and-drop se bhi data move kar sakte hain.

Data Move Karne Ke Liye

1. Cell ya column select karein.
2. Cursor ko selection ke border par le jaayein.
3. Jab cursor four-arrow icon ban jaye, tab drag karein.
4. Data nayi location par move ho jayega.

Data Copy Karne Ke Liye

Agar move nahi balki copy karna chahte hain:

• Ctrl key daba kar rakhein.
• Ab data ko drag karein.

Isse original data wahi rahega aur selected data ki ek copy nayi location par ban jayegi.

8. Blank Cells Ko Ek Click Mein Delete Karein

Kabhi-kabhi Excel sheet mein import kiye gaye data ya manually enter kiye gaye records ke beech kaafi blank cells reh jaate hain. Ye blank cells formulas, sorting aur data analysis ko galat bana sakte hain.

Agar aap manually blank cells delete karenge, to bahut time lag sakta hai. Isliye Excel ka Filter feature use karna sabse fast method hai.

Blank Cells Delete Karne Ke Steps

1. Jis column ko clean karna hai use select karein.
2. Data → Filter par click karein.
3. Filter dropdown open karein.
4. (Blanks) option select karein.
5. Sirf blank cells dikhai denge.
6. In rows ko select karein.
7. Home → Delete → Delete Sheet Rows par click karein.

Ab saare blank rows remove ho jayenge aur data clean ho jayega.

Photoshop Kya Hai Aur Photoshop Ki History

Kab Use Karein?

9. Wildcard Search Se Jaldi Data Find Karein

Agar aapko exact word ya spelling yaad nahi hai, tab bhi Excel mein search karna possible hai.

Iske liye Wildcard Characters ka use hota hai.

Excel Ke Do Important Wildcards

Example

Agar sheet mein ye values hain:

• Excel Basic
• Excel Advanced
• Excel Formula

Aur aap search karte hain:

Excel*

To teeno records mil jayenge.

Agar search karte hain:

A?C

To ABC, ADC, A1C jaise values match hongi.

Shortcut

Ctrl + F

Ye Find dialog box open karta hai.

Official Excel Keyboard Shortcuts

10. Kisi Column Se Unique Values Nikalein

Kai baar ek column mein same value baar-baar repeat hoti hai.

Jaise:

Agar sirf unique cities chahiye, to Advanced Filter use karein.

Steps

1. Column select karein.
2. Data → Advanced par click karein.
3. Copy to another location choose karein.
4. Destination select karein.
5. Unique Records Only tick karein.
6. OK dabayein.

Excel duplicate values hata kar sirf unique values dikha dega.

Before vs After

Ye feature customer lists, product names aur survey reports ke liye bahut useful hai.

Image: (Existing image same rakhein)

11. Data Validation Se Galat Entry Rokien

Agar aap chahte hain ki users sirf valid data hi enter karein, to Data Validation feature ka use karein.

Example:

Employee Age sirf 18 se 60 ke beech honi chahiye.

Steps

1. Cell select karein.
2. Data → Data Validation
3. Allow = Whole Number
4. Minimum = 18
5. Maximum = 60

Ab agar koi 10 ya 100 enter karega to Excel warning dega.

Input Message Bhi Add Karein

Input Message tab mein likhein:

Please enter your age between 18 and 60 years.

User jab cell select karega to ye message automatically show hoga.

Data Validation Ke Common Uses

12. Ctrl + Arrow Se Lightning Fast Navigation

Agar worksheet mein hazaron rows hain, to mouse scroll karna bahut slow ho sakta hai.

Isliye Excel ka shortcut use karein.

Shortcuts

Ye shortcut large Excel files mein bahut time bachata hai.

Example

Agar sheet mein 25,000 rows hain,

Mouse se scroll karne mein:

⏳ 15–20 seconds

Ctrl + Down Arrow:

⚡ 1 second

Comparison

13. Row Ko Column Mein Convert Karein (Transpose)

Kai baar data horizontal hota hai jabki hume vertical format chahiye.

Example

Before

| Name | Rahul | Amit | Neha |

After

Ye kaam Transpose feature se hota hai.

Steps

1. Data Copy karein.
2. Empty location select karein.
3. Home → Paste → Transpose

Excel automatically row ko column aur column ko row bana dega.

Kab Useful Hai?

• Survey Reports
• Student Marks
• Attendance Sheet
• Dashboard Creation
• Pivot Table Preparation

Comparison

Image: (Existing image same rakhein)

14. Excel Mein Data Ko Properly Hide Karein

Bahut log Hide Row ya Hide Column use karte hain.

Lekin ye data aasani se unhide kiya ja sakta hai.

Agar aap values ko temporarily invisible banana chahte hain to Custom Number Format use karein.

Steps

1. Cells select karein.
2. Ctrl + 1
3. Number tab open karein.
4. Custom select karein.
5. Type box mein likhein:

;;;

6. OK par click karein.

Ab values screen se gayab ho jayengi.

Lekin Formula Bar mein data safe rahega.

Microsoft Outlook Tips

Hide Methods Comparison

Note: Ye method security ke liye nahi, sirf presentation ke liye hai. Sensitive data ko protect karne ke liye Protect Sheet ya Password Protection ka use karein.

Computer Tips Articles

Frequently Asked Questions (FAQs)

1. Excel Tricks kya hote hain?

Excel Tricks aise shortcuts, formulas aur hidden features hote hain jo Microsoft Excel mein kaam ko faster, easier aur more accurate bana dete hain. Inki madad se aap data analysis, calculations aur spreadsheet management ko efficiently kar sakte hain.

Microsoft Excel Help & Learning

2. Kya ye Excel tricks beginners ke liye suitable hain?

Haan. Is article mein bataye gaye sabhi Excel tricks beginners aur professionals dono ke liye useful hain. Agar aap Excel seekhna shuru kar rahe hain, to ye guide aapke liye ek achha starting point hai.

3. Kya ye tricks Microsoft Excel 365 aur latest versions mein bhi kaam karti hain?

Ji haan. Ye adhiktar tricks Microsoft Excel 2010, 2013, 2016, 2019, 2021 aur Microsoft 365 mein bhi kaam karti hain. Kuch options ka interface alag ho sakta hai, lekin features lagbhag same rehte hain.

4. Excel mein sabse useful shortcut kaunsa hai?

Sabse popular aur useful Excel shortcuts mein Ctrl + A, Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + F, Ctrl + Arrow Keys aur Ctrl + Shift + L shamil hain. Ye shortcuts rozana kaam ko kaafi fast bana dete hain.

Computer Keyboard Shortcut Keys

5. Excel mein duplicate aur unique data kaise identify karein?

Excel ke Advanced Filter ya Remove Duplicates feature ka use karke aap kisi bhi column se duplicate values hata sakte hain aur sirf unique records dekh sakte hain.

6. Excel mein blank cells ko jaldi kaise delete karein?

Blank cells delete karne ke liye Filter, Go To Special ya Delete Sheet Rows feature ka use kar sakte hain. Ye methods manually delete karne se kaafi fast aur accurate hote hain.

7. Excel mein data validation ka kya use hai?

Data Validation ki madad se aap users ko sirf valid data enter karne ki permission de sakte hain. Iska use age limit, marks, date, mobile number ya dropdown list banane ke liye kiya jata hai.

8. Kya Excel shortcuts yaad rakhna zaroori hai?

Har shortcut yaad rakhna zaroori nahi hai. Lekin frequently use hone wale shortcuts jaise Copy, Paste, Undo, Find, Save aur Navigation yaad rakhne se aapki productivity kaafi improve ho sakti hai.

9. Excel seekhne ke baad kaun-kaun si jobs mein fayda milta hai?

Microsoft Excel ka knowledge Data Entry, Accountant, Office Assistant, MIS Executive, Data Analyst, HR, Banking, Finance, Sales aur Business Management jaise kai fields mein bahut useful hota hai.

10. Excel expert banne ke liye kitna time lagta hai?

Agar aap roz 30–60 minute practice karte hain, to 1–2 mahine mein Excel ke basic aur intermediate features achhi tarah seekh sakte hain. Advanced formulas, Pivot Tables, Charts aur Macros seekhne ke baad aap apni Excel skills ko aur improve kar sakte hain.

11. Microsoft Excel free mein kahan se download kar sakte hain?

Microsoft Excel ko official Microsoft website ya Microsoft 365 subscription ke through use kiya ja sakta hai. Web version (Excel Online) kuch basic features ke saath free bhi available hai.