← All Lessons
LESSON 03

Rows, Columns & Cells

Excel mein Rows, Columns aur Cells kya hote hain aur inka use kaise hota hai.

📘 Excel Sheet Ko Samjhein

Excel worksheet ek table ki tarah hoti hai. Is table mein bahut saari horizontal aur vertical lines hoti hain.

Inhi se Excel mein Rows, Columns aur Cells bante hain.

💡 Excel mein data enter karne ke liye hum Cells ka use karte hain.

➡️ Row Kya Hai?

Excel mein left se right jaane wali horizontal line ko Row kehte hain.

Rows ko numbers se identify kiya jata hai.

Row 1 Row 2 Row 3 Row 4 Row 5

Example

Agar aap Row 3 mein data enter kar rahe hain, to aap Excel ki teesri horizontal line use kar rahe hain.

⬇️ Column Kya Hai?

Excel mein upar se neeche jaane wali vertical line ko Column kehte hain.

Columns ko letters se identify kiya jata hai.

A B C D E F G

Example

Column A, Column B aur Column C Excel ke alag-alag columns hain.

🔲 Cell Kya Hai?

Jab ek Row aur Column ek doosre ko cross karte hain, to jo box banta hai use Cell kehte hain.

Column A + Row 1 = A1 Column B + Row 2 = B2 Column C + Row 3 = C3

Excel mein data enter karne ke liye hum cells ka use karte hain.

📍 Cell Address

Har Excel cell ka ek unique address hota hai.

Cell address banane ke liye pehle Column Letter aur phir Row Number likha jata hai.

A1 B5 C10 D25

Example

B5 ka matlab hai Column B aur Row 5.

📝 Cell Mein Data Enter Karna

Kisi cell mein data enter karne ke liye pehle cell ko select karein aur phir data type karein.

A1 → Name B1 → Age C1 → City A2 → Som B2 → 18 C2 → Kanpur

Is tarah Excel mein rows aur columns ke through information organized hoti hai.

📊 Practical Example

Maan lijiye hume employees ka data banana hai.

A1 = Name B1 = Age C1 = Department A2 = Rahul B2 = 25 C2 = Sales A3 = Amit B3 = 28 C3 = IT

Yahan Row 1 mein headings hain aur Row 2 aur Row 3 mein employee data hai.

⭐ Important Points

📝 Lesson Summary

Aaj humne Excel ke teen important parts Rows, Columns aur Cells ke baare mein seekha.

Excel mein professional data work karne ke liye in teen concepts ko samajhna bahut important hai.

💡 Next lesson mein hum seekhenge: Excel mein Data Entry.
← Previous Lesson Next Lesson →