Excel: Assign names for cells and cell ranges

In this practical tip, we will show you how to assign names for cells and cell ranges in Excel. There are two different methods for this.

Assign names for cells and cell areas - how it works

You can assign names to the cells directly in the work area:

1. Select the cell or range of cells that you want to name.
2. Then click on the name field to the left of the function line. For example, "A1" appears here when you select the first cell.
3. You can now change the name and call "Hello" instead of "A1".

Alternative: distribute names via the menu

You can also give cells and cell ranges names via the menu:

1. Right-click the cell or range of cells you want to name.
2. In the opened menu, select "Name area".
3. Enter your name next to "Name" and save with "OK".