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

• What a range is — any selection of cells Excel treats as a single unit: a single cell (A1), an entire column (A:A), a full row (1:1), or a rectangular block (A1:C10);

• Why ranges matter — instead of adding cells one by one, you can select a range (e.g., K2:K54) and apply a function to it all at once. Excel assumes everything inside a range is related and should be processed together;

• Naming rules — a named range must start with a letter and cannot contain spaces;

• Benefits of named ranges — total_cost is easier to read and write than K2:K54, and if the data expands, you can update the named range in one place without rewriting any formulas that use it;

• Editing a named range — go to the Formulas tab → Name Manager → select the name → Edit → update the address in the Refers To box (e.g., extend K2:K54 to K2:K55) → click OK;

• Navigation and deletion — use the Name Box to jump directly to a named range for faster navigation. Deleting a name removes only the name, not the data — but any formulas that referenced it will return errors.