ITKokka
Lesson 7 ยท Note 3

Worksheets, Rows, Columns and Cells

๐Ÿ“Œ The Short Note

Download

๐Ÿ“– Explanation

Worksheets, Rows, Columns and Cells

Introduction

A spreadsheet worksheet is organised as a grid. The grid makes it possible to enter information in a structured way, identify individual locations, and select groups of cells for calculations or formatting.

This note explains the structure of a worksheet, how columns and rows are named, how to identify the active cell, how cell addresses are written, and how to move around a worksheet using the keyboard.

1. What Is a Worksheet?

A worksheet is a page in a spreadsheet application where data is entered, stored and organised. It consists of rows and columns that form a grid of cells.

A spreadsheet file, commonly called a workbook, can contain more than one worksheet. The worksheets are usually shown as sheet tabs at the bottom of the application window.

Worksheet and workbook

  • Worksheet: One individual working page containing rows, columns and cells.
  • Workbook: The spreadsheet file that can contain multiple worksheets.
Example: A school marks workbook

A teacher may create one workbook named Student Marks. It could contain separate worksheets named Term 1, Term 2 and Term 3. Each worksheet can store the marks for a different term.

Cells arranged in a grid

A cell is the box formed where a row and a column intersect. It is the basic location used to enter data in a worksheet.

A cell can contain:

  • Text, such as a student's name.
  • A number, such as an examination mark.
  • A formula, such as =B2+C2.

The selected cell is identified by its cell address.

2. Naming Columns

Columns run vertically from top to bottom. They are identified using letters.

  • The first column is A.
  • The next columns are B, C, D, and so on.
  • After column Z, the column names continue with combinations of letters, such as AA, AB, AC, and so on.

Column headings appear across the top of the worksheet.

Selecting a column heading selects the entire column.

3. Naming Rows

Rows run horizontally from left to right. They are identified using numbers, starting from 1.

  • The first row is 1.
  • The next rows are 2, 3, 4, and so on.

Row numbers appear along the left side of the worksheet.

Selecting a row number selects the entire row.

4. Active Cell

The active cell is the cell that is currently selected in a worksheet. It is usually shown with a bold or clearly visible border.

When a user types data or a formula, the entry is placed in the active cell. The cell's address can be identified from its column letter and row number.

Example: Selecting cell C3

If the user selects the cell at the intersection of column C and row 3:

  • The active cell is C3.
  • Any data typed next will be entered into C3, unless the selection changes.

The active cell can be changed by clicking another cell or by using keyboard navigation keys.

5. Cell Addresses

Each cell has a unique address called a cell reference or cell address. It is formed by writing the column letter first, followed by the row number.

Format: Column letter + Row number

Examples:

  • A1 โ€“ column A, row 1.
  • B3 โ€“ column B, row 3.
  • D5 โ€“ column D, row 5.
  • AA10 โ€“ column AA, row 10.

The order matters: the column identifier comes before the row number.

Example: Understanding B3

The reference B3 identifies the cell in column B and row 3. It does not mean row B or column 3.

Cell references are used in formulas to refer to values stored in other cells. For example, =A1+B1 adds the values in cells A1 and B1.

6. Scrolling and Navigating a Worksheet

A worksheet can contain more rows and columns than are visible on the screen. Users can move between cells using the arrow keys and other keyboard shortcuts.

Arrow keys

The four arrow keys move the active cell one cell at a time:

KeyFunction
โ†‘ Up ArrowMove one cell up
โ†“ Down ArrowMove one cell down
โ† Left ArrowMove one cell left
โ†’ Right ArrowMove one cell right

Useful keyboard shortcuts

ShortcutFunction
Arrow keysMove the active cell one cell in the chosen direction.
Ctrl + Arrow keyMove to the last cell containing data in that direction, according to the worksheet's navigation behaviour.
HomeMove to the beginning of the current row.
Ctrl + HomeMove to cell A1.
Ctrl + EndMove to the last used cell in the worksheet.
Page UpMove the worksheet view up by one screen.
Page DownMove the worksheet view down by one screen.

Note: Keyboard shortcut behaviour can vary slightly between spreadsheet applications and versions. The shortcuts above follow the functions presented in the supplied note.

Moving the active cell

When an arrow key is pressed, the active cell moves in the selected direction. The worksheet view may also scroll when the active cell moves beyond the currently visible area.

Example: Navigating from a selected cell
  • Press the Up Arrow to move to the cell above.
  • Press the Down Arrow to move to the cell below.
  • Press the Left Arrow to move to the cell on the left.
  • Press the Right Arrow to move to the cell on the right.

7. Range of Cells

A range of cells is a group of two or more cells selected in a worksheet.

A range is written using a colon (:) between the address of the first cell and the address of the last cell.

Types of ranges shown in the note

Vertical range: A range extending down a column.

  • Example: B2:B5
  • It includes B2, B3, B4 and B5.

Horizontal range: A range extending across a row.

  • Example: A2:D2
  • It includes A2, B2, C2 and D2.

Rectangular range: A range covering multiple rows and columns.

  • Example: A1:C3
  • It includes all cells from columns A to C and rows 1 to 3: A1, B1, C1, A2, B2, C2, A3, B3 and C3.

How to read a range

For B2:B5:

  1. The first cell is B2.
  2. The last cell is B5.
  3. The colon indicates the selected range between those two cell addresses.

A range can be used when applying formatting, selecting data, or performing calculations on several cells.

Example: Adding marks in a range

If a student's marks are entered in cells B2 to B5, the range B2:B5 identifies all four cells. A spreadsheet formula such as =SUM(B2:B5) can add the values in that range.

8. Important Differences to Remember

TermMeaning
WorksheetA working page in a spreadsheet.
WorkbookA spreadsheet file that can contain multiple worksheets.
RowA horizontal line of cells, identified by numbers.
ColumnA vertical line of cells, identified by letters.
CellThe intersection of a row and a column.
Active cellThe cell currently selected.
Cell address/referenceThe unique location of a cell, such as B3.
RangeA group of cells, such as A1:C3.

Exam-Focused Points

Key Idea 1: Columns are named using letters (A, B, C, โ€ฆ, Z, AA, AB, โ€ฆ), while rows are named using numbers starting from 1.

Key Idea 2: A cell address is written with the column letter first and the row number second. For example, B3 means column B, row 3.

Key Idea 3: A range is a group of cells. The first and last cell addresses are separated by a colon, for example A1:C3.

Remember these keyboard shortcuts from the note:

  • Ctrl + Home โ€“ go to A1.
  • Ctrl + End โ€“ go to the last used cell.
  • Home โ€“ go to the beginning of the row.
  • Page Up and Page Down โ€“ move the worksheet view up or down by one screen.

Summary

A worksheet is a grid made up of rows and columns, and each intersection forms a cell. Columns use letters and rows use numbers. The active cell is the currently selected cell, and its unique address is written with the column letter followed by the row number. A range identifies a group of cells using a colon between the first and last cell references. Arrow keys and keyboard shortcuts help users navigate a worksheet efficiently.

Share:
โ† Spreadsheet InterfacesEntering Data into a Worksheet โ†’