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.