-
Select a cell or range of cells to name.
-
On the Formulas tab, select Define Name.
-
Type a Name, check Refers to (the range), and Scope.
-
Add a Comment and select OK.
Naming a range of cells isn't currently possible in Excel for the web. You can, however, name a range of cells in the Excel desktop app.
-
To open the desktop app, at the top of the ribbon, select Editing > Open in Desktop App.
Don't have the Excel desktop app? Try or buy Microsoft 365.