How to edit Excel named Cells - Revision history

Maxim@tygron.com at 11:25, 13 July 2026

2026-07-13T11:25:40Z

← Older revision		Revision as of 11:25, 13 July 2026
Line 23:		Line 23:

	[[File:Excel_quick_start_6a.jpg\|thumb\|left\|600px\|Errors in cell naming]]		[[File:Excel_quick_start_6a.jpg\|thumb\|left\|600px\|Errors in cell naming]]
	~~<br clear~~=~~all>~~
			{{article end
			\|seealso=
			* [[Indicator]]
			* [[Indicators Tutorial]]
			* [[TQL]]
			* [[Plotly]]
			\|howtos=
			* [[How to upload an Indicator Excel]]
			\|api=*[[Api session items indicators]]
			*[[Api session event editor indicator]]
			}}

Maxim@tygron.com at 11:25, 13 July 2026

2026-07-13T11:25:03Z

← Older revision		Revision as of 11:25, 13 July 2026
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 [[Excel]] cells should be done carefully, because any mistake here will result in an error during the calculation of the [[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>

Maxim@tygron.com at 11:24, 13 July 2026

2026-07-13T11:24:40Z

← Older revision		Revision as of 11:24, 13 July 2026
Line 17:		Line 17:

	[[File:ExcelNameManagerMultiSelect-Q3-2015.jpg\|thumb\|left]]		[[File:ExcelNameManagerMultiSelect-Q3-2015.jpg\|thumb\|left]]
			<br clear=all>

			===Fixing Name Problems===
			In the Name Manager panel you can edit both the name as well as the cell it refers to. This method allows you to correct a naming issues. It is possible to (incorrectly) refer two or more labels to the same cell, as the image below shows. In this example both a <code>MAQUETTE</code> and a <code>CURRENT</code> query are referring to the same cell. One will override the other and the order is unpredictable. Please make sure to resolve these issues first. You can delete the name, or let it refer to another cell.

			[[File:Excel_quick_start_6a.jpg\|thumb\|left\|600px\|Errors in cell naming]]
	<br clear=all>		<br clear=all>

Maxim@tygron.com at 11:23, 13 July 2026

2026-07-13T11:23:45Z

← Older revision		Revision as of 11:23, 13 July 2026
Line 1:		Line 1:
	~~===Editing Named Cells===~~		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>

Maxim@tygron.com: 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. File:ExcelNameManagerRibbon-Q3-2015.jpg|How to open the Excel Na..."

2026-07-13T11:23:18Z

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..."

New page

===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 Name Manager
File:Excel_quick_start_4.jpg|Excel Name Manager panel
</gallery>

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:

[[File:ExcelNameManagerEdit-Q3-2015.jpg|thumb|left|Edit Cell Name]]
<br clear=all>
To delete a cell name, highlight the entry and select Delete. A message will ask for confirmation.

[[File:ExcelNameManagerDelete-Q3-2015.jpg|thumb|left|Delete Confirmation Message]]
<br clear=all>
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.

[[File:ExcelNameManagerMultiSelect-Q3-2015.jpg|thumb|left]]
<br clear=all>