Explainry Tutorials to Expert in IT

Naming a cell or a range in Excel

How to name a range

There are different ways to name a cell or a range, such as:

Method 1

Select the range A1:A7, go to the Name Box and type your desired name.


Method 2

To name a range through the Name Manager, execute the following steps:

1- Select the range A1:A5.

2- In the Formulas tab, go to the Defined Names section and click Name Manager.

Result. Name Manager box will appear.

Shortcut key alert: You can also open the Name Manager box by pressing Ctrl + F3.

3- On the Name Manager box window, click New or press N button.

4- Enter the desired Name e.g. ‘Price’ and press OK.

5- Result. Excel will named the range as ‘Price’.

Next: Use names in formulas

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved