In a brand new installation of Excel 2010, the Paste button only allows the pasting of Text. Formulas paste as text and there are no other options. All of the Paste Special options are missing. I have viewed screen shots of Excel 2010 on the web, where there are many Paste options shown. Is there a configuration setting to turn the Paste options On? Office 2010 was packaged with an HP computer with Windows 7 Home Premium 64-bit OS (all updates performed), and then activated. Office SP1 was reported as not needed. I was working extensively with Excel 2007 (and early) and have not encountered this problem. I have seen others ask this question in various forums, but have not seen a solution.
Thanks to everyone for their help.
See my March 20, 2012 post for more details on the solution.