Excel 2007 Paste Special

[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?

 

[macropod]

Hi Ken,

What happens when you select both cells and press Ctrl-D?

 

[Ken Williams]

Hi Ken,

What happens when you select both cells and press Ctrl-D?

Thanks, Ctrl-D does what I want. I never knew about that.

 

[macropod]

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.