How to edit Excel named Cells: Difference between revisions
Created page with "===Editing Named Cells=== The naming of cells should be done carefully, because any mistake here will result in an error during the calculation of the Excel Indicator. Once a cell has been labelled with a name, the Microsoft Excel Name Manager must be used to edit or remove the name of the cell. The Name Manager can be opened as follows; select Formulas → Defined Names → Name Manager. <gallery> File:ExcelNameManagerRibbon-Q3-2015.jpg|How to open the Excel Na..." |
No edit summary |
||
| Line 1: | Line 1: | ||
The naming of [[Excel]] cells should be done carefully, because any mistake here will result in an error during the calculation of the Excel Indicator. Once a cell has been labelled with a name, the Microsoft Excel Name Manager must be used to edit or remove the name of the cell. The Name Manager can be opened as follows; select Formulas → Defined Names → Name Manager. | |||
The naming of cells should be done carefully, because any mistake here will result in an error during the calculation of the Excel Indicator. Once a cell has been labelled with a name, the Microsoft Excel Name Manager must be used to edit or remove the name of the cell. The Name Manager can be opened as follows; select Formulas → Defined Names → Name Manager. | |||
<gallery> | <gallery> | ||
Revision as of 11:23, 13 July 2026
The naming of Excel cells should be done carefully, because any mistake here will result in an error during the calculation of the Excel Indicator. Once a cell has been labelled with a name, the Microsoft Excel Name Manager must be used to edit or remove the name of the cell. The Name Manager can be opened as follows; select Formulas → Defined Names → Name Manager.
-
How to open the Excel Name Manager -
Excel Name Manager panel
On the Excel Name Manager panel you can find all defined names in the workbook and to what cells these names refer. If you want to edit a cell name, highlight it and select the Edit Button. The following panel will then appear:
To delete a cell name, highlight the entry and select Delete. A message will ask for confirmation.
You can even select multiple entries at once, by pressing the Shift key when selecting. This can be very convenient when rearranging all VAR_# entries for instance.
