How do I paste range name list in worksheet?
 

How can I paste a list of range names into a worksheet in Excel 2007. The
pasr list option is not in the name manager

Answer: How do I paste range name list in worksheet?
 

To paste a list of range names into a worksheet in Excel 2007, you can follow these steps:
[list=1][*]Open the Name Manager by clicking on the Formulas tab in the ribbon, then clicking on the Name Manager button.[*]In the Name Manager dialog box, select all the range names that you want to paste into the worksheet. You can do this by clicking on the first range name, then holding down the Shift key and clicking on the last range name in the list. Alternatively, you can hold down the Ctrl key and click on each range name that you want to select.[*]Once you have selected all the range names that you want to paste, click on the Copy button.[*]Open a new worksheet or an existing worksheet where you want to paste the range names.[*]Click on the cell where you want to start pasting the range names.[*]Right-click on the cell and select the Paste Special option.[*]In the Paste Special dialog box, select the Values option and click OK.[*]The range names will now be pasted into the worksheet as a list.

Note: If the Paste List option is not available in the Name Manager, it may be because you are using an older version of Excel. In this case, you can still copy and paste the range names as described above.

How do I paste range name list in worksheet?
 

In the Ribbon, click the Formulas tab
In the Defined Names group, click Use in Formula
Click Paste Names
Click Paste List

abaja wrote:
How can I paste a list of range names into a worksheet in Excel 2007. The
pasr list option is not in the name manager


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html