Another Option Button provided with Excel, is the Paste Option button.

 

 

If you click the menu indicator on the button (small downward pointing triangle), a menu will drop down with options regarding whether the source or destination format will be retained, whether the cell widths will be adjusted, or if the cells should be linked.

 

These Smart tags and option buttons provide context sensitive options and information based on the data you enter and the actions you take when building a workbook.

 

You can configure Smart Tags by selecting Tools->Autocorrect Options from the menu bar, and selecting the Smart Tags tab on the AutoCorrect dialogue box.

 

If you change the smart tag settings, click the OK button to activate the changes.