I am using Excel 2003. I am trying to paste data into an existing spreadsheet. On my boss' computer, when the paste is complete, at the bottom right hand corner of the pasted area is a little clipboard icon. If you right click on the clipboard, you can choose the option "match formatting".

I have tried everything suggested in the help menu to make that little clipboard appear. Any other suggestions, other than tools-options-edit-show paste options?

I answered my own question. I needed to go to tools-autocorrect-options-smart tags and activate the smart tags. Thanks for being such a valuable resource!