Excel Data Entry and Formatting – Beginner Computer Course - Lessons 37

Social Media Point
FREE COMPUTER DIPLOMA
Module 7 – Lesson 37

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 TypeExample
TextQasim, Hyderabad, Student
Numbers100, 2500, 75.5
Dates13/11/2026
Time09:30 AM
Formulas=A1+B1

3. How to Enter Data in Excel

  1. Open Microsoft Excel.
  2. Create a Blank Workbook.
  3. Click the cell where you want to enter information.
  4. Type the required text, number, or date.
  5. Press Enter to complete the entry.
Example: Click cell A1, type Student Name, and press Enter. Then click A2, type Ali, and press Enter.

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.

Important: Clearing cell contents is different from deleting an entire row or column. Be careful when removing records.

6. Copy, Cut and Paste

ActionWindows ShortcutPurpose
CopyCtrl + CCopies selected information
CutCtrl + XMoves selected information when pasted
PasteCtrl + VInserts copied or cut information
UndoCtrl + ZReverses the last action
SaveCtrl + SSaves 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.

FormatExample Display
Number1250.50
CurrencyRs. 1,250.50 (depending on settings)
Percentage75%
Date13-Nov-2026
Text00125 (preserves leading zeros when stored as text)
Important CNIC tip: CNIC numbers should generally be stored as text to preserve all digits and leading zeros. Do not treat long identification numbers as ordinary calculation values.

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 NameDepartmentSalaryStatus
AliAccounts45000Active
SaraHR50000Active
AhmedIT55000Active
  1. Enter the headings and employee information.
  2. Make the heading row bold.
  3. Apply a fill colour to the heading row.
  4. Add borders to the complete table.
  5. Center-align the Department and Status columns.
  6. Format the Salary column as a number.
  7. Change the font size of the headings.
  8. 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

Answered: 0 / 10 Questions Live Score: 0 / 10

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

Previous Post Next Post