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?






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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question