Formulas to the Clipboard

M

Meg Az.

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)
 
B

Bernie Deitrick

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
Paste Formula 3
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Paste Special Menu 1
Use TODAY() function as the criteria in a SUMIF formula 1
Using formula to convert date result to text 3
Mapping integers to strings 6
"Can not empty the clipboard" 2

Top