Skip to main content
Workforce LibreTexts

18.6: Defined Names Group

  • Page ID
    13703
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)

    clipboard_ea323a2558128314b4b714896877ef491.png

    Cells can be named in excel to simplify equations in Excel. For example, I may decide to enter the numbers 1-5 in cells A1-A5. By highlighting cells A1-A5 we can name these cells “numbers” in the upper left-hand corner name box by entering the text. Now, these group of cells will be referred to by the title “numbers” when using a formula or searching for specific cell locations and calculations.

    clipboard_e88b7898918e523cbf3b2bef6a821bc94.png

    I can create a formula in cell A6 =sum(numbers) and Excel will understand that I want to add all of the data in Cells A1-A5 because I named those cells numbers. The formula bar displays the cell name.

    clipboard_e587e6717ac25728d404cb53810690f6d.png

    The Name Manager icon clipboard_e8cb65193ef5e3d8a75aa3da01be1e248.png in the Defined Names group allows for easy management of cell names. Users can delete, edit, and create new names to use in cells and formulas.

    clipboard_e13199c287a2a251692e0747231c995c6.png

    By selecting the Define Name/icon, users may utilize the New Name Dialog box to select name their cells and also provide a definition of what their name (or group) of cells is named for. This is another way to name a group of cells than was previously provided.

    clipboard_e59c8544db48197176e974a85135f81ce.png

    The Use in Formula icon clipboard_e910dc0ab7f92427bb03b13119481715f.png contains a drop-down that contains a list of all the named ranges in the workbook. The Paste Names command displays the "Paste Name" dialog box that can paste a name into the formula bar for use when creating a formula.

    clipboard_ee33af11ef31dcd8101eb580a54ea71a3.png

    Finally, the Create from Selection clipboard_e1b7cad3d930f9a2afb4c8d2b95060b8a.png Displays the "Create Names from selection" dialog box. This enables you to name a selected range of cells using a row or column title previously entered.

    clipboard_eaa1568e16e7e8a1bcb5a6e667ac0e8bc.png


    18.6: Defined Names Group is shared under a CC BY license and was authored, remixed, and/or curated by Nick Heisserer.

    • Was this article helpful?