Workbook, Worksheet, Rows, Columns, and Cells
Microsoft Excel organizes data using Workbooks and Worksheets. Data is entered into cells that are arranged in rows and columns. Understanding these basic components is essential for working efficiently in Excel.
What is a Workbook?
A Workbook is an Excel file that contains one or more worksheets. When you create a new Excel file, a workbook is automatically created.
Examples:
- Student_Record.xlsx
- Employee_Salary.xlsx
- Sales_Report.xlsx
Each workbook can contain multiple worksheets to organize different types of data.
What is a Worksheet?
A Worksheet is a single spreadsheet page inside a workbook. It consists of rows, columns, and cells where data can be entered, edited, and analyzed.
By default, worksheets are represented by sheet tabs at the bottom of the Excel window.
Examples:
- Sheet1 – Student Details
- Sheet2 – Marks Report
- Sheet3 – Attendance Record
Difference Between Workbook and Worksheet
| Workbook | Worksheet |
|---|---|
| An Excel file. | A page inside the workbook. |
| Can contain multiple worksheets. | Contains rows, columns, and cells. |
| Example: Sales_Report.xlsx | Example: January Sales Sheet |
What are Rows?
Rows run horizontally across the worksheet and are identified by numbers.
- Row 1
- Row 2
- Row 3
- And so on…
Modern Excel worksheets contain 1,048,576 rows.
What are Columns?
Columns run vertically in the worksheet and are identified by letters.
- Column A
- Column B
- Column C
- And so on…
Modern Excel worksheets contain 16,384 columns, ending with column XFD.
What is a Cell?
A Cell is the intersection point of a row and a column. It is the basic unit used to store data in Excel.
Every cell has a unique address called a Cell Reference.
| Column | Row | Cell Address |
|---|---|---|
| A | 1 | A1 |
| B | 5 | B5 |
| C | 10 | C10 |
Types of Data Stored in Cells
- Text: Student Name, City Name
- Numbers: Marks, Salary, Quantity
- Dates: 01-01-2026
- Formulas: =SUM(A1:A10)
Cell Range
A group of selected cells is called a Range.
Examples:
- A1:A10 → Cells from A1 to A10
- B1:D5 → Rectangular range of cells
- C:C → Entire Column C
- 5:5 → Entire Row 5
Selecting Cells and Ranges
- Click a cell to select it.
- Click and drag to select multiple cells.
- Press Ctrl and click to select non-adjacent cells.
- Press Ctrl + A to select the entire worksheet.
Shortcut Keys
| Shortcut Key | Purpose |
|---|---|
| Ctrl + A | Select entire worksheet. |
| Ctrl + Space | Select entire column. |
| Shift + Space | Select entire row. |
| Ctrl + Home | Move to cell A1. |
| Ctrl + End | Move to the last used cell. |
