Auto Fill Microsoft Excel ka ek smart feature hai jo kisi cell ke data, pattern, series ya formula ko automatically doosre cells mein fill karta hai.
Iska main purpose repetitive data entry ko fast aur easy banana hai. Excel existing data ke pattern ko identify karke usi pattern ko aage continue kar sakta hai.
Auto Fill ke liye generally Fill Handle ka use kiya jata hai.
Steps:
A1 = 1
A2 = 2
Dono cells ko select karke Auto Fill karne par:
1, 2, 3, 4, 5, 6…
A1 mein:
01/01/2026
Agar Auto Fill kiya jaye, Excel dates ko continue kar sakta hai:
01/01/2026 → 02/01/2026 → 03/01/2026 → 04/01/2026
A1 mein:
January
Auto Fill karne par:
January → February → March → April → May…
A1 mein:
Monday
Auto Fill:
Monday → Tuesday → Wednesday → Thursday…
Auto Fill ka important use formulas ko multiple cells mein copy karna hai.
Example:
| A | B | C |
|---|---|---|
| 100 | 200 | =A2+B2 |
| 150 | 250 | |
| 200 | 300 |
Agar C2 mein formula:
=A2+B2
hai aur Auto Fill karke neeche drag kiya jaye, Excel automatically formulas ko adjust karega:
C2 = A2+B2
C3 = A3+B3
C4 = A4+B4Isse har row ka calculation manually type karne ki zarurat nahi padti.
Excel mein Auto Fill ke baad kuch options available ho sakte hain:
| Option | Meaning |
|---|---|
| Copy Cells | Same data/formula ko copy karta hai |
| Fill Series | Number ya pattern ko continue karta hai |
| Fill Formatting Only | Sirf formatting copy karta hai |
| Fill Without Formatting | Data fill karta hai, formatting nahi |
| Flash Fill | Example ke basis par data pattern automatically identify karta hai |
Auto Fill ka use real-life Excel work mein bahut hota hai:
✅ Time save karta hai
✅ Repetitive work reduce karta hai
✅ Formula copying easy banata hai
✅ Series automatically create karta hai
✅ Large data sheets mein useful hai
✅ Manual errors ko reduce karne mein help karta hai
Leave a Reply