If your Paste Special option is missing, look here. Paste Special allows you to paste using the formatting of your choice.
Learn how to create flexible, effective conditional formats in Excel 2007.
In Excel 2010, lock or freeze rows or columns to keep them in view, or split panes in your worksheet that can scroll separately from each other.
When I go to the Backstage view, I select Options and on the first selection there is a User Interface Options where you have 2 check boxes. I don't understand where the Mini Toolbar is located and
To customize your work environment in Microsoft Excel 2010, you can use the trusty Excel Options dialog box. In this dialog box, for example, you can add commands to the ribbon