. Fill Handle kya hai?

Fill Handle Microsoft Excel ka ek smart aur time-saving feature hai. Iski help se hum kisi cell ki value, formula, pattern, date, number series ya sequence ko automatically adjacent cells mein fill kar sakte hain.

Cell ko select karne par uske bottom-right corner mein ek chhota square दिखाई देता है, jise Fill Handle kaha jata hai.

2. Fill Handle kaise use karein?

1. Kisi cell mein data enter karein.
2. Cell ko select karein.
3. Cell ke bottom-right corner par mouse le jayein.
4. Cursor + (plus) shape mein change ho jayega.
5. Mouse ko drag karein.
6. Excel automatically data ko required cells mein fill kar dega.

3. Example – Number Series

A1 mein 1 aur A2 mein 2 enter karein.

Dono cells ko select karke Fill Handle ko neeche drag karein.

Excel automatically series continue karega:

1, 2, 3, 4, 5, 6, 7…

4. Example – Date Series

A1 mein:

01-01-2026

enter karke Fill Handle ko drag karne par Excel dates ko automatically continue kar sakta hai:

• 01-01-2026
• 02-01-2026
• 03-01-2026
• 04-01-2026

Iska use attendance, payment schedule, daily sales report aur monthly records mein hota hai.

5. Formula Fill Karna

Fill Handle ka sabse important use formulas ko quickly copy karna hai.

Example:

A2 = 100
B2 = 200
C2 = A2+B2

Agar C2 ke formula ko neeche drag kiya jaye, Excel next rows ke according references ko automatically adjust kar sakta hai.

For example:

C2 = A2+B2
C3 = A3+B3
C4 = A4+B4

6. Text Series

Fill Handle kuch common patterns ko bhi recognize kar sakta hai.

Example:

Monday
Tuesday
Wednesday
Thursday
...

Similarly:

January
February
March
April
...

7. Fill Handle ke Main Uses

8. Fill Handle aur Auto Fill

Auto Fill ek general Excel feature hai jisme Excel existing pattern, formula ya sequence ko automatically continue karta hai.

Fill Handle woh small square/drag control hai jiske through hum Auto Fill ko quickly apply karte hain.

9. Fill Handle vs Copy-Paste

Copy-Paste mein hum manually data copy karke destination par paste karte hain.

Fill Handle mein Excel pattern ko identify karke automatically continue kar sakta hai.

Isliye large worksheets mein Fill Handle kaafi fast aur convenient hota hai.