What Is A Range In Microsoft Excel
A range in Microsoft Excel is a cell or group of cells that you refer to or work with together. For example, A1:B3 includes every cell between A1 and B3, covering two columns and three rows. Ranges tell Excel which cells to use when calculating.
Which licences fit your PC setup?
Prices are an AUD snapshot, not a live quote. Confirm variant and total on the listing.
-

Office 2021 Pro Plus key
$57.00 AUD
-

Office 2019 Pro Plus key
$45.00 AUD
-

Microsoft 365 Pro Plus, 5 devices
$15.00 AUD
$29.00
How to read an Excel range reference
Excel normally identifies each cell by its column letter and row number. A1 is the cell where column A meets row 1. For a rectangular range, a colon joins the top-left cell address to the bottom-right cell address.
The reference A1:B3 includes A1, A2, A3, B1, B2 and B3. Both endpoints are included, along with every cell between them. A range can contain numbers, text, dates, formulas and empty cells.
- A1 refers to one cell.
- A1:A10 refers to part of one column.
- A1:D1 refers to part of one row.
- A1:D10 refers to a rectangle across several rows and columns.
- A:A refers to all of column A, while 1:1 refers to all of row 1.
A range does not need to be highlighted to exist. A formula can refer to B2:B10 while you are working elsewhere in the worksheet. Selecting cells simply makes that range the target for your next action.
Adjacent and separate selections
An adjacent, or contiguous, range forms one unbroken rectangle. Excel also lets you select separate areas, such as A1:A5 and C1:C5, at the same time. These are non-contiguous selections.
Separate selections are useful for applying the same formatting to different areas. Some commands require a single rectangular range, so a selection that works for formatting may not work for another task.
How to select a range
For a small range, click its first cell and drag to its last cell. For a larger rectangle, click the first cell, hold Shift and click the last cell.
When you know the address, use the Name Box to select the range directly:
- Click the Name Box to the left of the formula bar.
- Type the range address, such as A1:D20.
- Press Enter to select those cells.
You can also click a column letter or row number to select an entire column or row. In Excel for Windows, hold Ctrl while selecting additional areas to create a non-contiguous selection. Hold Shift and press an arrow key to extend a selection one cell at a time.
Before typing or applying a command, check the highlighted area. Selecting an entire column affects a much larger area than selecting only the populated cells.
Use ranges in formulas
Functions use range references to identify their input cells. For example, =SUM(B2:B10) adds the numbers in B2 through B10. You can type the reference yourself or select those cells while entering the formula.
| Task | Formula | What it returns |
|---|---|---|
| Add values | =SUM(B2:B10) | The total of the numeric values |
| Find an average | =AVERAGE(B2:B10) | The arithmetic mean of the numeric values |
| Count numbers | =COUNT(B2:B10) | The number of cells containing numeric values |
| Find the smallest value | =MIN(B2:B10) | The lowest numeric value |
| Find the largest value | =MAX(B2:B10) | The highest numeric value |
AVERAGE ignores empty cells in a referenced range but includes cells containing zero. COUNT counts numeric values, including dates stored as numbers; use COUNTA when you need to count non-empty cells instead.
Put a total outside the range it adds. For example, entering =SUM(B2:B10) in B11 avoids including the formula's own cell, which would create a circular reference.
Relative and absolute range references
A relative reference changes when you copy a formula to another position. Copying =SUM(B2:B10) one column to the right produces =SUM(C2:C10).
Dollar signs lock the referenced rows or columns when copying. The formula =SUM($B$2:$B$10) keeps the same range when copied elsewhere. Mixed references lock only one part: $B2 fixes column B, while B$2 fixes row 2.
These rules describe copying and filling formulas. Cutting and moving cells can affect references differently, so check dependent formulas after reorganising a worksheet.
Apply formatting and organise data
Select a range before changing its number format, font, fill colour, alignment or borders. For example, select the amount cells in an expenses sheet and apply a currency format. Conditional formatting can highlight cells within a range when they meet a rule.
For charts, select the relevant labels and values together so Excel can use them as the chart's source data. For sorting and filtering, include the full related dataset and its headers.
Be especially careful when sorting one column in a table of related information. Sorting only the amounts while leaving names and dates in place can break the connection between each record's fields. If Excel offers to expand the selection, check that it includes every column belonging to those records.
Name a range for clearer formulas
A named range gives cell references a readable label. If B2:B10 contains sales figures, naming it Sales lets you write =SUM(Sales).
- Select B2:B10.
- Click the Name Box and type Sales.
- Press Enter to create the name.
- Enter =SUM(Sales) in a cell outside that range.
Names cannot contain spaces or be cell addresses such as B10. Use a descriptive name such as Monthly_Sales when one word is insufficient. Open Name Manager from the Formulas tab to review or change the cells a name refers to.
A name assigned to a fixed range does not automatically include every new entry added below it. If your list regularly grows, consider an Excel table and structured references, which adjust as table rows are added. Check the referenced area whenever you extend a dataset.
For related Office tasks, the Microsoft Office blog includes guides to Office activation using Command Prompt and finding an Office product key using Command Prompt.
To practise, enter a few amounts in B2:B5, type =SUM(B2:B5) in B6, then change one amount and check the updated total.
Other editions for separate workloads
Other editions for separate workloads; prices in AUD, confirm the total on the listing.
-

Windows 11 Pro key
$14.99 AUD
$29.00 -

Office 2024 Pro Plus key
$20.00 AUD
$39.00 -

Windows 11 Home key
$18.88 AUD
$37.00
How to check this worked
- Open Settings, System, Activation and confirm the edition shown.
- Enter the key and run activation; expect a green tick within a minute.
- Reboot and re-check activation survives the restart.
FAQ
What else should you know before buying?
- What do I need before starting?
- Read the requirements and confirm the edition first; the steps assume the machine is compatible.
- How do I know the licence is genuine?
- Activate on Microsoft's servers and check Settings, System, Activation. A working activation is the test.
- Is this a subscription?
- Keys sold here are one-time lifetime licences. Microsoft 365 plans are billed by Microsoft instead.
- What if the key fails?
- Email hi@ms.codes with the order number and a screenshot. Replacement or refund applies within 30 days.
Check who prepared and reviewed this guide
- Written by
- MS.Codes editorial
- Reviewed by
- Support team
Last verified: (source review; see test status above).