Entering, Editing and Formatting Data
Master Data Entry, Data Types, Editing Cells (F2), Copy/Paste Shortcuts, Font Styling, Borders, Number Formats, and Text Alignment
1. What is Data Entry?
Data entry means entering information into Excel cells. You can enter text, numbers, dates, times, and formulas.
For example, an office employee may enter beneficiary names, CNIC numbers, district names, and payment amounts into an Excel worksheet.
2. Types of Data in Excel
| Data Type | Example |
|---|---|
| Text | Qasim, Hyderabad, Student |
| Numbers | 100, 2500, 75.5 |
| Dates | 13/11/2026 |
| Time | 09:30 AM |
| Formulas | =A1+B1 |
3. How to Enter Data in Excel
- Open Microsoft Excel.
- Create a Blank Workbook.
- Click the cell where you want to enter information.
- Type the required text, number, or date.
- Press Enter to complete the entry.
4. How to Edit Data
You can correct or change information in an existing cell.
- Double-click a cell: Edit the contents directly inside the cell.
- Press F2: Edit the selected cell in many Windows Excel versions.
- Formula Bar: Select a cell and edit its contents in the formula bar.
- Replace data: Select a cell and type new information to replace its existing contents.
5. How to Delete Data
Select a cell or range and press the Delete key to clear its contents. You can also use Home → Clear → Clear Contents.
6. Copy, Cut and Paste
| Action | Windows Shortcut | Purpose |
|---|---|---|
| Copy | Ctrl + C | Copies selected information |
| Cut | Ctrl + X | Moves selected information when pasted |
| Paste | Ctrl + V | Inserts copied or cut information |
| Undo | Ctrl + Z | Reverses the last action |
| Save | Ctrl + S | Saves the workbook |
On a Mac, use Command (⌘) instead of Ctrl for these common shortcuts.
7. What is Cell Formatting?
Cell formatting changes the appearance of information without necessarily changing its actual value.
Excel provides several formatting options:
- Font type and font size.
- Bold, italic, and underline.
- Font colour and cell fill colour.
- Cell borders.
- Text alignment.
- Number, date, percentage, and currency formats.
8. Font Formatting
Font formatting changes the appearance of text inside cells.
- Bold: Makes text thicker and darker.
- Italic: Slants text.
- Underline: Adds a line below text.
- Font Size: Makes text larger or smaller.
- Font Colour: Changes the colour of text.
Select the cell or range, then use the Font options on the Home tab.
9. Cell Colour and Borders
Fill Colour changes the background colour of selected cells. Borders add lines around cells or ranges to organize information.
For example, use a dark green fill with white bold text for the headings of an office record.
10. Text Alignment
Alignment controls where information appears inside a cell.
- Left Align: Places content toward the left.
- Center: Places content in the middle.
- Right Align: Places content toward the right.
- Top, Middle, and Bottom Align: Control vertical positioning.
11. Number Formatting
Number formatting controls how values are displayed.
| Format | Example Display |
|---|---|
| Number | 1250.50 |
| Currency | Rs. 1,250.50 (depending on settings) |
| Percentage | 75% |
| Date | 13-Nov-2026 |
| Text | 00125 (preserves leading zeros when stored as text) |
12. Wrap Text and Merge Cells
Wrap Text displays long content on multiple lines within the same cell.
Merge Cells combines selected cells into one larger cell. Use it carefully because merging can affect sorting and filtering. For many data tables, keeping each record in separate cells is better.
13. Practical Exercise
Create the following employee record in Excel:
| Employee Name | Department | Salary | Status |
|---|---|---|---|
| Ali | Accounts | 45000 | Active |
| Sara | HR | 50000 | Active |
| Ahmed | IT | 55000 | Active |
- Enter the headings and employee information.
- Make the heading row bold.
- Apply a fill colour to the heading row.
- Add borders to the complete table.
- Center-align the Department and Status columns.
- Format the Salary column as a number.
- Change the font size of the headings.
- Save the workbook as Employee Record.xlsx.
14. Lesson Summary
- Data entry means entering information into cells.
- Excel supports text, numbers, dates, times, and formulas.
- Existing cell contents can be edited or cleared.
- Copy, Cut, and Paste help manage data.
- Formatting improves the appearance and readability of a worksheet.
- Number formats control how values are displayed.
15. Test Your Knowledge – Interactive MCQs
Enter your name and select your answers. Each answer locks immediately with instant feedback.
Entering, Editing and Formatting Data – Online MCQ Test
10 Questions | 10 Marks | One-Time Selection
Final Test Result
Congratulations! You have completed Lesson 37. Continue to Lesson 38 to advance further in your Excel diploma program.
© Social Media Point | Free Digital Education
