In Microsoft Excel, you can create and use two types of names:ĭefined name - a name that refers to a single cell, range of cells, constant value, or formula. Looking at the screenshot below, which of the two formulas are easier for you to understand? Or, you can give meaningful names to the ranges and individual cells and supply those names to the formula: Similarly, in Microsoft Excel, you can give a human-readable name to a single cell or a range of cells, and refer to those cells by name rather than by reference.įor instance, to find the total of sales (B2:B10) for a specific item (E1), you can use the following formula:

For example, instead of saying 'the city lying at latitude 40.7128° N and longitude 74.0059° W, you simply say 'New York City'. In everyday life names are widely used to refer to people, objects and geographical locations.

How to create a dynamic named range in Excel.

How to name columns and rows (create names from selection).

Create a named range using Name Manager.

Define a name using the Define Name option.

This tutorial will not only teach you how to create a named range in Excel, but will also show how to leverage this feature to make your formulas much easier to write, read, and re-use. The reason is that very few users understand the essence of Excel names. Names in Excel are a paradoxical thing: being one of the most useful features, they are often considered pointless or nerdy. You will also learn how to edit, filter and delete defined names in Excel. The tutorial explains what an Excel name is and shows how to define a name for a cell, range, constant or formula.

Cant select cell office mac 2017