Excel 2007 Paste Special

  • Thread starter Thread starter Ken Williams
  • Start date Start date
K

Ken Williams

Hi, I have a worksheet open in Excel 2007. I have a cell with a formula
in it. I simply want to copy and paste the formula to the cell below
it. Copy/paste in Excel 2003 was fine and it automatically adjusted the
the cell references. Now with 2007 it only copies the value, not the
formula. I try to "paste special" but all I get is a dialog box with
"Unicode Text" and "Text" options. Nothing like its suppose to be.

Any ideas?
 
Hi Ken,

Glad it worked, but it still doesn't solve the basic problem (presumably you still can't copy a cell with a formula, paste it
somewhere else and still have a formula in the destination cell). I'm not sure what the cause of that is.
 
Back
Top