The Grid: Cells, References & Data Types
Rows, columns, A1 references, ranges, and the three data types Excel treats differently — numbers, text and dates.
- Navigate the grid and name any cell or range with A1 notation
- Tell apart numbers, text and dates — and why Excel treats them differently
- Enter and edit data with the keyboard shortcuts that save real time
A marks sheet where 92 is stored as text sorts below 8. A budget where "1,200" is text never sums. Half of every "Excel bug" in a college submission is a data-type problem in a cell that looks fine on screen.
The grid: columns are lettered A, B, C…; rows are numbered 1, 2, 3…. A cell is its column letter + row number — B3 is column B, row 3. The Name Box (top-left, left of the formula bar) always shows the active cell's name; click it and type a reference to jump there.
Ranges: a rectangle of cells written first-cell:last-cell — A1:A10 is a column of ten cells, B2:D5 is a 3×4 block, 2:2 is all of row 2. Every function in this course takes ranges as input.
Three data types Excel treats differently:
- Numbers — right-aligned by default, sum in SUM(), compare numerically.
- Text — left-aligned, IGNORED by SUM(). A number typed with a leading apostrophe ('92) is forced to text.
- Dates — secretly numbers. 1 Jan 1900 is serial 1; today is a five-digit number with a date format on top. This is why date arithmetic works and why a "date" stored as text never sorts chronologically.
Entry shortcuts worth muscle memory: Enter moves down, Tab moves right, Enter on the last row wraps to the top of the range you were typing into. F2 edits the active cell in place. Ctrl+Enter fills the whole selection with what you typed. Escape cancels an entry mid-way.
| What it names | |
|---|---|
| B3 | Single cell — column B, row 3 |
| A1:A10 | Column range — 10 cells |
| B2:D5 | Block — 3 columns × 4 rows |
| 2:2 | Entire row 2 |
| $B$3 | Absolute cell — never shifts when copied |
Select any range and the Name Box area shows Count and Sum instantly — no formula needed. Select cells and look bottom-left of the status bar; right-click the status bar to add Average too.
Typing '92 stores TEXT that looks like a number. It will not sum, it sorts after every real number, and SUM() silently skips it. Watch the alignment: left means text.
- 1
Count the cells
COUNT(C2:C11) returns 8, not 10 — two cells are not numbers.
- 2
Find them
ISNUMBER(C2) filled down (Ctrl+D) returns FALSE on the two text cells.
- 3
See why
Those two were pasted from a portal export with a leading apostrophe — they are left-aligned.
- 4
Fix
Select the column: Data → Text to Columns → Finish converts text-numbers in place. Or multiply a helper column by 1.
Solution
Two marks were stored as text (left-aligned). Text-to-Columns or a 1× helper converts them; SUM then returns the true 428.
Paste any ten numbers into A1:A10, then force two of them to text with a leading apostrophe. Run COUNT, SUM and AVERAGE — record how each treats the text cells, then convert them and re-run.
Hint: COUNT counts numbers only; COUNTA counts everything; SUM and AVERAGE ignore text.
Assuming SUM ignores text silently — the total is just "a bit low"
A skipped cell is not a rounding error; it is missing data. Cross-check COUNT against the expected row count every time a total surprises you.
Editing a cell when you meant to select a range
F2 edits in place; Enter commits and moves. If you typed into a cell by accident, Esc cancels with no change.
Why does SUM ignore a cell containing a number that was typed with a leading apostrophe?
The apostrophe forces text storage. Text is never included in SUM/AVERAGE/MIN/MAX even when it looks like a number; Excel only includes numeric-typed cells.
Source: Data types — the single most examined Excel concept in placement tests.
- A1 notation: column letter + row number; ranges use first:last.
- Numbers, text and dates are three different types — dates are secretly numbers.
- A leading apostrophe forces text; left-alignment is the visual tell.
- Ctrl+Enter fills a whole selection; F2 edits in place; Esc cancels.
