Data Entry & Formatting
Clean spreadsheet ki foundation correct data entry hoti hai. Is chapter me text, numbers, dates, editing, AutoFill, alignment aur number formats ko practical way me samjhenge.
Excel me data ke common types
- Text: names, city, product name.
- Numbers: quantity, marks, price.
- Dates: 16-Sep-2026 jaisi values.
- Percentages: 80%, 12.5%.
Agar number ko text ke roop me store kar diya, formulas expected result nahi de sakte. Data type ko visually nahi, behavior se bhi samjho.
Edit aur replace
Cell select karke direct new value type karne se old content replace ho sakta hai. Existing content edit karne ke liye formula bar ya edit mode use kar sakte ho.
Fill Handle / AutoFill
Excel patterns ko continue kar sakta hai. Example 1, 2 se series continue karna, ya same formula ko neeche copy karna.
Formatting vs actual value
Formatting appearance change karti hai; underlying value zaroori nahi badalta. Example 0.8 ko Percentage format dene par 80% dikh sakta hai.
Useful formatting tools
- Bold headers
- Currency / Accounting format
- Percentage format
- Date format
- Decimal places
- Wrap Text
- Horizontal/vertical alignment
- Column width adjustment
Avoid over-formatting
Har cell ko alag color dena professional spreadsheet nahi banata. Formatting ka purpose hierarchy aur readability improve karna hai.
Practice — Simple marks sheet
- Name, Marks aur Percentage headers banao.
- 3 students ka data enter karo.
- Header bold karo.
- Percentage column ko Percentage format do.
- Column width readable banao.