The object explorer displays variables and objects that are visible to the current script. It is only visible when a script is the active document in the workspace.
Go to workbook object
Go to a workbook object by holding Ctrl and clicking the node in the object explorer.
Rename workbook object
Press F2 to rename a workbook table, column, or named range.
Renaming database objects is currently not supported.
Drop to editor
Drag and drop a node into the editor to insert its name. Hold down Alt while dropping to insert all of the node's children's names instead.
Names are quoted if needed.