View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Copying formulas from Excel 2003 to Excel 2007

What do you mean by "do not get the option"?
Are you saying that when you select paste special there is no formula option
or do you mean you don't know how to paste special in 2007?

If the latter it's in the home tab to the left, you can also right click in
the cell where you want to paste it


--
Regards,

Peo Sjoblom




wrote in message
ups.com...
Hello,

I am trying to copy a cell from a spreadsheet created in Excel 2003
and opened in Excel 2007. After copying that cell I am trying to paste
the formula into a new Excel 2007 spreadsheet but I do not get the
option to Paste Special Formula, it only pastes the value. Any input
into what I may be doing wrong would be very helpful.

Thanks in advance.