I am trying to copy a cell range (which has formula) from one spreadsheet file to a another, but only the values get pasted not the formula. How can I copy paste such that the formula gets copied instead of the values?

Kalpa Pathum Welivitigoda
http://about.me/callkalpa