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.
 

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

Similar Threads

I can't copy and paste equations 0
paste formula from another file 1
Excel Copy and Paste Special problem 1
Any way to Paste without Relative reposition? 6
Macro that copies values from column A (from formula) to B (paste value) 1
Excel ignore formula 8
Can't Copy and Paste in Excel 2003 0
Blank Charts and Paste Special 5

Back
Top