Archive of Mr Excel Message Board

Back to Dates in Excel archive index
Back to archive home

Adding a formula to multiple cells after the fact

Posted by John on August 27, 2001 8:04 AM

I occationally set up a sheet with just a number in the cell and no formula. Sometimes I need to go back and change these cells to a formula. Is there an easy way to do this other than hitting F2 on each indivudual cell and changing that way. For instance if I want to make one column add something else to the number already entered.
Thanks

paste as values

Posted by Eric on August 27, 2001 9:49 AM

put the formula in a different column, referencing the values in the column you want to change. Then copy the formula and "paste special" "values" into the original column and delete the formula column. Should be faster than F2.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.