Microsoft Excel is a spreadsheet application used to enter, organize, calculate, and analyze information. The basic unit of an Excel worksheet is a cell. Users can enter different types of information into cells and format the data to make a worksheet clear, organized, and professional.

1. Understanding Cells

A cell is the intersection of a row and a column in an Excel worksheet. Each cell has a unique address based on its column letter and row number.

For example:

• A1 – Column A, Row 1
• B5 – Column B, Row 5
• D10 – Column D, Row 10

The selected cell is called the active cell, and users can enter or edit data in it.

2. Entering Data in Cells

Users can enter different types of data into an Excel worksheet, including:

• Text: Names, subjects, departments, product names, etc.
• Numbers: Marks, quantities, prices, salaries, etc.
• Dates: 07/09/2026, 7-Sep-2026, etc.
• Times: 10:30 AM, 2:45 PM, etc.
• Formulas: Calculations such as =A1+B1
• Functions: Built-in calculations such as =SUM(A1:A10)

Basic steps:

1. Select a cell.
2. Type the required information.
3. Press Enter to complete the entry.
4. Use the arrow keys or mouse to move to another cell.

3. Editing Cell Data

Existing information in a cell can be changed whenever required.

Users can:

• Double-click a cell to edit its contents.
• Select a cell and edit the information in the Formula Bar.
• Press F2 to edit the active cell.
• Select unwanted data and press Delete to remove it.

4. Formatting Text in Cells

Cell formatting changes the appearance of data without changing its actual value.

Common formatting options include:

• Font Type: Changes the text style.
• Font Size: Changes the size of the text.
• Bold: Makes important information stand out.
• Italic: Slants the text.
• Underline: Adds a line below text.
• Font Color: Changes the text color.
• Fill Color: Adds a background color to cells.

5. Number Formatting

Excel provides different number formats depending on the type of information being entered.

Common formats include:

• General
• Number
• Currency
• Percentage
• Date
• Time
• Accounting

For example, a value such as 5000 can be displayed as ₹5,000 using an appropriate currency format.

6. Alignment and Text Control

Alignment determines how data is positioned inside a cell.

Users can apply:

• Left alignment
• Center alignment
• Right alignment
• Top, middle, or bottom alignment

Other useful options include:

• Wrap Text: Displays long content on multiple lines within the same cell.
• Merge & Center: Combines selected cells and centers the content.
• Text Orientation: Changes the direction or angle of text.

7. Adjusting Rows and Columns

Users can change the size of rows and columns to display data properly.

They can:

• Increase or decrease column width.
• Change row height.
• Use AutoFit to automatically adjust the size according to the content.

Proper row and column sizing improves the readability of a worksheet.

8. Applying Borders

Borders help separate data and organize information visually. Users can apply borders around individual cells, selected ranges, or entire tables.

Borders are commonly used for:

• Headings
• Tables
• Financial data
• Student marksheets
• Reports

9. Using Format Painter

Format Painter allows users to copy the formatting from one cell or range to another without copying the actual data.

For example, if one heading has a particular font, size, alignment, and color, Format Painter can quickly apply the same formatting to another heading.

10. Practical Example

Suppose a student creates a marksheet containing Student Name, Roll Number, Subject, Marks, and Result. They can enter the information into separate cells, make the headings bold, apply borders, adjust column widths, format marks as numbers, and use alignment and colors to make the worksheet easy to read.