• 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

    Read about our Excel Development Projects

    A leading Auctioneer came to xlteq to help streamline and automate their global headcount reporting in Excel. This included real-time clarification of total headcount coupled with detailed location status functionality.

    Find our more 

    A Danish financial services company asked our Excel Consultants for support with preparing their client investment portfolios. This task now takes less than a minute per customer and is delivered in a format selected by the client then presented as a visually effective Investment Portfolio Dashboard.

    Find out more