Named Ranges in Excel Online: How to Use Them in Formulas

Why does your Excel Online formula look like =VLOOKUP(A2,$B$2:$D$847,3,FALSE) when it could read =VLOOKUP(A2,EmployeeTable,3,FALSE)? If you're writing formulas that you or anyone else will need to read six months from now, that difference matters more than most people realize. Named ranges in Excel Online are usable, but there's a catch that almost every tutorial glosses over, and knowing it upfront will save you real frustration.

Here's the honest version of how this works in 2026: you can use named ranges inside formulas in Excel for the web, but you cannot create them there. No Name Manager. No Define Name dialog. The browser version of Excel simply doesn't support it yet. So the workflow runs desktop-first: you create the name in Microsoft Excel on your desktop, save to OneDrive or SharePoint, and then use it freely inside formulas in Excel Online. That's exactly what this article walks through, step by step.

What You'll Be Able to Do — and the One Named Range Limitation in Excel Online You Need to Know First

By the end of this guide, you'll be writing formulas in Excel for the web that reference named ranges instead of raw cell references: cleaner, easier to audit, and far less likely to break silently. If you're already comfortable with cell references in Excel, named ranges are the next logical step. Instead of $B$2:$D$847, you give that range a name once, and every formula that needs it uses the name instead.

The limitation is real and worth naming clearly: creating a named range directly in Excel Online is not available as of right now. The Name Manager, which desktop Excel users rely on to create, edit, and delete named ranges, does not exist in the browser version. Microsoft's own documentation confirms this. If you're working purely in the browser and expecting a Define Name option somewhere in the menus, you won't find it.

What does work in Excel for the web: using any named range already defined in desktop Excel, typing that name into the formula bar, and using the Name Box dropdown to navigate to named ranges. That's actually enough to work with, as long as you set things up in desktop Excel first.

---

Step 1: Create Your Named Range in Desktop Excel Before You Open the File in the Browser

Everything in Excel Online depends on this step being done first. The named range has to exist in the workbook before the file ever touches a browser, which means opening Microsoft Excel on your desktop and defining the name there.

Use Define Name or the Name Box to Set It Up on Desktop

Two methods work here. The Name Box method is faster for simple cases. The Define Name dialog gives you more control.

Name Box method:

1. Select the cell or range you want to name.
2. Click the Name Box — the small field on the left side of the formula bar that normally shows your cell address, like B2.
3. Type your range name and press Enter.

Define Name method:

1. Select the cell or range.
2. Go to Formulas → Define Name.
3. Type a name, confirm the cell reference in the Refers to field, and click OK.

A few naming rules worth knowing: no spaces allowed (use underscores — Employee_Table, not Employee Table), names can't start with a number, and names are case-insensitive. SalesData and salesdata refer to the same thing. A range called SalesData beats $B$2:$B$847 every time. The formula doesn't care. You do.

The Name Box method is the one I reach for first — it's two keystrokes once you know it. For a broader look at how formulas connect, the formulas and functions overview covers that ground well.

Save to OneDrive or SharePoint So the File Opens in Excel Online

Once your named ranges are defined, save the workbook to OneDrive or SharePoint. Excel Online works with files stored in Microsoft's cloud, so the save location isn't optional — it's the mechanism that makes the browser version accessible. After saving, open the file through OneDrive or by selecting Edit in Browser from SharePoint. The named ranges you created travel inside the workbook file, so they'll be available the moment the file opens.

---

Step 2: Use Named Ranges in Excel Online Formulas (and Navigate to Them with the Name Box)

Once you've saved the file with named ranges defined, you're ready to use them in the browser — and this part works exactly the way you'd want it to.

Type the Named Range Directly into a Formula in the Formula Bar

Click a cell in Excel for the web, start typing your formula in the formula bar, and use the named range exactly as you'd use a cell reference. If you named your employee data EmployeeTable, your formula looks like this:

=VLOOKUP(A2,EmployeeTable,3,FALSE)

Named ranges work with any function that accepts a range: SUM, IF, XLOOKUP, COUNTIF, all of them. Wherever you'd normally type $B$2:$D$100 into a formula, you can type your range name instead. The formula evaluates identically. The difference is that anyone reading it, including you three months from now, actually knows what it's referencing. That's not cosmetic. It's a genuine readability and reliability gap that most users never close.

If a name doesn't make sense, you're forced to think about what you're doing. Raw range references let you be vague. Names don't — and that's a good thing.

Select a Name from the Name Box to Jump to That Range

The Name Box in Excel Online has a dropdown. Click the small arrow next to it and you'll see a list of all named ranges defined in the workbook. Selecting one jumps your view directly to that range and selects it. This is useful when you're auditing formulas or verifying that the range you named actually covers what you think it covers.

It's not the full Name Manager — you can't edit or delete names from here — but for navigation and formula use, it does the job. If you want a solid foundation before going deeper into Excel's formula layer, the Excel for Beginners starter guide is worth reading first.

---

Common Mistakes When Using Named Ranges in Excel Online

Three stumbles show up repeatedly, and all three are easy to avoid once you know the shape of them.

If you take one thing from this article: create named ranges on desktop Excel before moving to the browser, then use them freely in your Excel Online formulas. The setup is a one-time cost. The readability payoff lasts as long as the workbook does.

---