Tables and Data Types

The three layers of data organisation in Excel — from raw cell selections to intelligent, auto-expanding structures.

1. Ranges

A range is Excel's most fundamental unit of selection. Before you can use a formula, format data, or build a table, Excel needs to know which cells you're referring to. That answer is always a range.

Ranges come in four forms. Each serves a different purpose:

• Single cell — A1;
• Full column — A:A;
• Full row — 1:1;
• Block — A1:C10.

Ranges are what allow Excel to scale. Instead of applying a formula cell-by-cell, you define the range once and Excel processes the entire block together. This is the key difference between a spreadsheet and a basic calculator.

2. Named Ranges

Cell references like K2:K54 are precise but fragile — if columns shift or someone else reads the formula, the intent is invisible. Named ranges solve this by giving a range a human-readable identifier.

How to create a named range:

1. Select the target range (e.g. K2:K54);
2. Click the Name Box — the field to the left of the formula bar showing the current cell address;
3. Type the name (e.g. Total_Cost) — no spaces allowed;
4. Press Enter to confirm.

How to edit or delete a named range:

1. Go to Formulas tab → Name Manager;
2. Select the name you want to modify;
3. Click Edit to change the range reference in the "Refers To" box, or Delete to remove it;
4. Click Close when finished.

3. Tables

A named range is still a static snapshot. If you add a row, you must manually update the range definition. Tables solve this — they are ranges that know they're growing.

How to create a table:

1. Click any cell inside your data range;
2. Press Ctrl+T (Windows) or Cmd+T (Mac);
3. Confirm the range and check "My table has headers";
4. Click OK — Excel now treats the data as a structured table.