The Object Selector is the second row of the , shown below marked in red at its default state.
It enables the user to browse through all the , of which the is either the same as, or a of, the currently selected type in the
Although seldom used, the displayed list may be further restricted by selecting a filter through the
Information on the current state of the Object Selector is immediately displayed in a popup window as the user hovers with the mouse over it, as shown below in a case where 4 objects of type have been produced in the spreadsheet.
The information concerns a) the objects of which the type is either the same as, or a of, the currently selected type in the and also b) all existing objects regardless of type.
It also allows the user to delete the objects in a) from Excel's memory.
Clicking on the Object Selector will display a list of all objects of the currently selected type, as shown below:
The three columns contain the following information:
First column: Object's
Second column: Object's type
Third column: Letter that identifies the object's
As the user hovers the mouse over the listed rows, the contents of each object appear in the , as shown below:
In practice, one never needs to browse through the objects in the Object Selector because the correct object is automatically selected as soon as the user selects a cell that contains a handle name.
For example, below is the wizard when the user has selected the cell G1 that contains the formula =ds(G2:H11) that returns the handle name &FxSwp_G1:1.1
As shown above, not only the Object Selector is set to display the handle name of the currently selected cell G1, but also the is set to the exact type of the corresponding object and the automatically displays the object's contents.
Furthermore, hovering the mouse over the Object Selector enables the users to execute certain tasks on that object, as shown below:
At this point, it would be worth to mention an interesting trick!
If a certain object is selected in the Object Selector, then choosing the function in the will populate the with corresponding to the selected object.
If then the user selects an empty spreadsheet cell and clicks on the Go button, the pasted data will be equal to those of the original object and therefore the new formula will create a new object that will have identical contents as the original one.
This can be useful if the original object has not been created using explicit input , but has been instead returned as the output of some formula or imported from a text file through the function.