| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to create table of cell names with the name's cell address
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to create table of cell names with the name's cell address
Yes,
With your Cursor where you want excel to DUMP the data Insert, Names, Paste.. Click on Paste-List Button.. HTH "WildwoodEngr" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I insert the address of a selected cell into a fixed cell | Excel Discussion (Misc queries) | |||
| How do I have a data table display cell names rather than values? | Excel Worksheet Functions | |||
| external import of multiple worksheet data & create pivot table | Excel Worksheet Functions | |||
| Replace a spreadsheets named cells/ranges with exact cell address. | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
