Ranges

Welcome to the First Island

This is where every Excel journey begins. Before you build formulas, dashboards, or massive workbooks, you need to understand how Excel groups cells together — and how to make those groups work for you instead of against you.

In this chapter you'll learn three things:

• What a range is and why Excel is built around it;
• How to turn a confusing K2:K54 into a readable named range like Total_Cost;
• How to upgrade a plain range into a real Excel Table that grows with your data automatically.

Watch the video below, then read through the recap and definitions. By the end of the chapter, the next island unlocks.

Key Takeaways

• A range is any group of cells Excel treats as one unit;
• Ranges are defined by two coordinates — start and end (A1:C10);
• A named range replaces an address with a readable label;
• Name Manager (Formulas tab) lets you edit, expand, or delete names;
• Ctrl / Cmd + T turns a range into a Table — with filters and auto-expansion built in.

What is a Range?

It can be:

• A single cell — A1;
• An entire column — A:A;
• An entire row — 1:1;
• A rectangular block — A1:C10.

Instead of acting cell by cell, Excel applies actions to the whole selected range at once. Write one formula referencing K2:K54, and Excel processes all 53 cells together. This is what makes Excel scale.

Named Ranges

A named range replaces a cell reference with a readable identifier. Instead of writing =SUM(K2:K54), you can write =SUM(Total_Cost) — same result, much clearer formula.

Names must start with a letter, no spaces allowed (use _ instead).