• Excel Defined Names

  • Excel Solutions - Defined Names

    You can give a cell (or range of cells) a name.

    For example, the following formula refers to two cells. [E1] is the price and [E2] is the VAT amount.

    Excel Tips Defined Names

    However, to make the formula easier to understand, we can give names to cells [E1] and [E2].

    Simply click on cell [E1] and in the Name box, type in a new name (in this example it is ‘Price’).

    Repeat for cell [E2] with the name of ‘VAT’

    Excel Developer Tips Defined Names

    You can now use these names in your formulas.

    Excel Developers Defined Names