Excel mein Data Entry kaise karein (Likhna aur Move Karna) : Lesson 29 — ComputerSeekhoAurJobPao

Lesson 29: Excel mein Data Entry kaise karein (Likhna aur Move Karna)

Hinglish English हिन्दी

Aap Kya Seekhenge?

• Excel mein Likhna Kaise Hai
• Enter aur Tab Ka Sahi Use
• Arrow Keys (Chaar Dishaayein)
• Galti Ho Jaye Toh Kya Karein
• Office Glossary
• Aaj Ki Practice

Ab tak aapne Excel ko samjha aur screen ko pehchana. Aaj hum Excel mein pehli baar data likhenge. Excel mein likhna bilkul normal typing jaisa hi hota hai, bas har cheez alag-alag box (Cell) mein likhi jati hai.

1. Excel mein Likhna Kaise Hai

Excel mein likhne ke liye:

• • Jis Cell mein likhna hai us par ek baar click karein
• • Keyboard se type karna shuru karein

Jo aap type karenge wo Cell ke andar dikhega aur upar Formula Bar mein bhi dikhega.

Jis cell par aap click karte hain uske charo taraf ek border dikhai deta hai. Isse Active Cell kehte hain. Excel mein jo bhi typing hoti hai wo hamesha Active Cell mein hoti hai.

2. Enter aur Tab Ka Sahi Use (Speed Magic)

Excel mein ek cell se dusre cell mein jaane ke liye mouse use karna slow hota hai. Isliye keyboard ki do keys yaad rakhiye:

Enter Key

Enter dabane se cursor niche wale cell mein chala jata hai. Excel default setting mein Enter dabane par cursor niche move karta hai, kyunki Excel ko lists aur tables banane ke liye design kiya gaya hai. Ye tab useful hai jab aap list bana rahe hote hain.

Example: Name → Ravi → Sita → Aman

Tab Key

Tab dabane se cursor right side wale cell mein chala jata hai. Ye tab useful hai jab aap ek line mein headings likh rahe hote hain.

Example: Name | City | Phone

3. Arrow Keys (Chaar Dishaayein)

Keyboard par jo arrow keys hoti hain wo bhi navigation ke liye use hoti hain:

• • Up Arrow: Upar jana
• • Down Arrow: Niche jana
• • Left Arrow: Bayein jana
• • Right Arrow: Dayein jana

4. Galti Ho Jaye Toh Kya Karein

Agar aapne kisi cell mein galat likh diya hai:

Tareeka 1 (Easy): Cell par Double Click karein aur galti theek karein.

Tareeka 2: Cell par click karke F2 key dabayein. (Ho sakta hai aap jis laptop mein kaam kar rahe hain usme fn key ke saath kaam karta ho F2 — tab aapko fn + F2 dabana padega.) Isse cell ke andar cursor aa jayega aur aap text edit kar sakte hain.

Letter Kaise Delete Karein:

• • Backspace: Cursor ke left side ka letter delete karta hai
• • Delete Key: Cursor ke right side ka letter delete karta hai

Agar aap galti se galat cell mein chale jayein to ghabrayein nahi. Arrow keys ya mouse se dobara sahi cell par aa sakte hain. Agar aapne galti se kuch delete kar diya ho to Ctrl + Z (Undo) dabaa kar wapas la sakte hain.

5. Office Glossary

• Data Entry: Computer mein information type karna
• Navigation: Ek cell se dusre cell mein jana
• Overwrite: Purane data ki jagah naya data likh dena
• Active Cell: Jis cell mein abhi typing ho rahi hoti hai

Aaj Ki Practice

Excel kholiye aur ye choti si list banaiye:

1️⃣ Cell A1 mein likhiye: Name — phir Tab dabaiye
2️⃣ Cell B1 mein likhiye: City — phir Tab dabaiye
3️⃣ Cell C1 mein likhiye: Phone
4️⃣ Ab Enter dabaiye aur niche aayein
5️⃣ Apne 3 doston ka data likhiye

Example format:
Ravi | Delhi | 98xxxx
Aman | Jaipur | 97xxxx
Sita | Lucknow | 99xxxx

Ab Arrow Keys se check kijiye ki aap har cell mein move kar pa rahe hain ya nahi.

💡 Tip: Excel mein hamesha check karein ki Active Cell kahan hai. Office mein fast data entry ke liye — Left hand → Tab key | Right hand → Enter key.

Is Lesson Mein Aapne Seekha:

• Excel mein kisi bhi cell mein click karke typing shuru kar sakte hain
• Enter key cursor ko niche le jaati hai — list banana ke liye useful
• Tab key cursor ko daayein le jaati hai — headings likhne ke liye useful
• Arrow keys se charon directions mein navigate kar sakte hain
• Galti sudharne ke liye Double Click ya F2 key use karein
• Kuch delete ho jaye to Ctrl + Z se Undo kar sakte hain

← Previous Home Next →

---

Home | About | Index | Welcome | Contact | Privacy Policy