How can I preserve the Name Manager names for formulas (using "Show Formula" view)

[sopczakm]

I have around 600 lines with cells that reference name manager values...when I look at the cell, it shows the name:

Ex: =Sales*Qty

When I double click to edit it changes to the cells itself:

Ex: =A1*B1

I want to copy ALL 600 lines using the "Show Formula" view...but when I do that it shows the A1 and B1, not my named cells. Any ideas?