How to create table of cell names with the name's cell address

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In QuattroPro, having created named cells, one can select "Output..." on the
naming dialog box and wherever the cell pointer is it will create a list of
the cell names you have created in one column, alphabetically, and in the
next column it will ist the cell address for which the name was created.
This is very useful for troubleshooting eliminating the constant "go to"
feature.
Does Excel have a similar feature available? I have not been able to find
it nor the right combination of words in Help to get the information, if it
exists.
Thank you.
 
Yes,
With your Cursor where you want excel to DUMP the data
Insert, Names, Paste.. Click on Paste-List Button..
HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Cell names of merged cells 1
VBA - retrieve data on last create named range from previous inserted named range 0
Help to create a macro 2
Reference Column of Named Cell vba 6
Sharing workbooks limitations - Merged Cells 12
Editing cell names 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0

Back
Top