How to name a range of cells in Microsoft Excel

I would like to say hi!

A formula in Microsoft Excel can contain a set of cells that are used for computations such as adding up numbers, calculating averages, and more.
For instance, you would write the words C2:C15 in the parenthesis of the formula if you wanted to include cells C2 through C15 in it.

The range of cells might also be given a name, which could subsequently be used in the formula as an alternative.
If the same set of cells is used in several formulae, using a predetermined name might make typing and remembering the formula easier.
Additionally, it can aid in preventing a formula’s modification when transferred between cells.

Name a group of cells

The procedures shown below can be used to give a range of cells in Microsoft Excel a name.

  1. Choose the required cell range in the Excel file.
  2. Select Define Name from the pop-up menu by performing a right-click on the chosen cells.
  3. Enter a name for the chosen cells in the Name box of the New Name window, then click Ok.