can't copy and paste formula from one worksheet to another
Posted by ks on January 08, 2002 9:05 AM
I am trying to copy data and formulas from one worksheet to another in the same workbook. Only the data is copying not the formulas.
Posted by Scott on January 08, 2002 9:11 AM
Are you using Edit-Paste, or are you using an icon? If you are using an icon, it's possible that it has been changed to paste values.
Posted by Andy Gee on January 08, 2002 9:12 AM
Select the formula in the formula bar (not the cell) and press control+insert to copy. Switch to the destination worksheet and select the cell you require and press shift+insert.
