MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Paste Formula as Value

Posted by Joseph Prusinski on May 03, 2001 6:59 AM

How do I do the Lotus Special Paste "Paste Formula as Value" in Excel?
What I want to accomplish is the copying of a column of formula results to another column as values instead of the formula.


Posted by Aladin Akyurek on May 03, 2001 7:12 AM

Use the option Edit|Paste Special then choose Values.