Formulas to the Clipboard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Why is it that a formula copied to the Office Clipboard is copied as a value rather than a formula? When you want to paste, you get a constant number rather than a formula. Pretty irritating

Thanks in advance for your response(s)
 
Meg,

Press F2 to enter edit mode, then select the formula and use Ctrl-C to copy
the formula.

Then when you paste, you'll get the formula.

HTH,
Bernie
MS Excel MVP

Meg Az. said:
Why is it that a formula copied to the Office Clipboard is copied as a
Click to expand...
value rather than a formula? When you want to paste, you get a constant
number rather than a formula. Pretty irritating.
 
Back
Top