How to copy a named cell to a new spreadsheet?

[Ruida]

I have a spreadsheet with some defined constants， for example, A1 is 3e8 and the name of A1 is defined as speed_of_light. Now I would like to copy these pre-defined constants to a new spreadsheet, so I can use these constants. The problem is the name of the cell is lost during this process, I can no longer use speed_of_light at the new spread sheet.

How can I copy the named cell to a new spreadsheet without loose its name?

Thanks a lot for your help!

[mariosv]

Take a look to this thread, maybe the same question:

Extract named formulas and use them in another spreadsheet

Hallo, I have named several formulas and use them in my spreadsheet. For example, through Insert → Names → Define, I created -among others- the “sum” formula which performs a sum up procedure. Could I possibly extract all the formulas I created along with their names, in order to use them in another spreadsheet? Even better, is there a way to store all the names and the corresponding formulas in a spreadsheet called “Formulas” and make it work from there? (probably not …) I would appreciate…