Lesson 2 – Cells, Rows, Columns & Worksheets

MS Excel Course • Level 1 – Beginner Essentials • Lesson 2

In this lesson, you will learn how Excel is structured— cells, rows, columns, and sheets.

What you will learn

• What cells, rows, and columns are
• How to select and manipulate them
• Inserting, deleting, resizing rows & columns
• Working with multiple worksheets

1. Understanding Cells

A cell is the smallest unit in Excel where data is stored. A cell address looks like A1:

• A → Column letter
• 1 → Row number

Click any cell to activate it.

2. Rows and Columns

Rows are numbered (1, 2, 3...). Columns are lettered (A, B, C...).

Selecting

• Click row number → select whole row
• Click column letter → select whole column
• Drag mouse → select multiple cells

Inserting & Deleting

• Insert row → Right-click row number → Insert
• Delete column → Right-click column → Delete

Resizing

• Double-click right border of a column → Auto-fit width
• Double-click bottom border of a row → Auto-fit height

You can select entire blocks using Ctrl + Shift + Arrow keys.

3. Worksheets

A workbook can have multiple sheets like Sheet1, Sheet2, etc.

• Add new sheet → + button near tabs
• Rename sheet → Double-click sheet name
• Move sheet → Drag left or right
• Delete sheet → Right-click → Delete

4. Practice Task

• Create a new Excel file
• Resize columns A–D
• Insert 2 new rows
• Rename sheet to Practice

Homework

• Create 3 sheets named Data, Marks, Reports
• Adjust the first 5 columns for neat spacing