How may I see the names of a separate Excel worksheet from within an active worksheet name-box? -


i using excel 2010

how may see names of separate worksheet within active worksheet name-box please?

regrads

the name box ever show names can use in current sheet, i.e. workbook scoped , current sheet scoped names, not names scoped other worksheets.

to see names sheet, open name manager, sort scope , scroll down worksheet name after.

name manager has filter button show workbook scoped versus worksheet scoped names, cannot filter on specific worksheet.


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -