MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.