Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
How to use the Paste Options button in Excel
Article ID: 291358 - View products that this article applies to.
This article was previously published under Q291358
This step-by-step article describes the functionality of the Paste Options button in Microsoft Excel.
The Paste Options button becomes available when you paste data into cells in Excel. The button appears just below the pasted selection. When you click the Paste Options button, you are presented with a list of options that determine how the data will be pasted into the cell. These options are also available on the Edit menu when you click Paste Special.
Use Paste OptionsThe Paste Options button offers you the following options:
Use Multiple ActionsIn some situations, it may be necessary to use a combination of the preceding options. For example, you may need to copy only the formatting and preserve the column widths. To do this, use the Paste Special function on the Edit menu.
Turn Off Paste OptionsTo prevent the Paste Options button from appearing, follow these steps, as appropriate for the version of Excel that you are running.
Microsoft Office Excel 2013 and 2010
Microsoft Office Excel 2007
Microsoft Office Excel 2003
For more information about how to use the various types of buttons and smart tags, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/289148/ )Smart tag functionality in Excel
(http://support.microsoft.com/kb/291357/ )How to use the AutoCorrect Options buttons in Excel
(http://support.microsoft.com/kb/291359/ )How to use the Auto Fill Options button in Excel
(http://support.microsoft.com/kb/291361/ )How to use the Error Checking Options button in Excel 2002
(http://support.microsoft.com/kb/291363/ )XL2002: How to Use the "Insert Options" Button in Excel 2002