Copy / Paste

[rbvinc]

I am copying formulas form spreadsheet A, and pasting in to
spreadsheet B. When paste it in B it pastes as 'values' instead
formulas. Is there any way I can fix this. In options/calculations
default is 'automatic'. I could not figure out how to paste as
formulas. Nedd help to fix this.
Thank you,

[xenixman]

Do a Paste Special
You should get a small sub-menu that allows you to select how & what you want pasted.

[brack]

Copy your formula, right-click, "paste specia" and then click the button that says "formulas."