If your Paste Special option is missing, look here. Paste Special allows you to paste using the formatting of your choice. Show helenclu luche dcscontentpm ITPro troubleshooting Normal CSSTroubleshoot CI 162524 CI 171649 MET150 office 3/31/2022 Paste Special option is missing or not working in Microsoft OfficeThe Paste Special option can make the task of pasting text go more smoothly by letting you choose which formatting you want to keep (source or destination) or by stripping all the formatting and just pasting the text. If you are having issues with the Paste Special option, continue on to the resolutions below. ResolutionTo see if the Paste Special option is enabled:
Ensure that all instances of the web browsers that you use are closed and try to use the Paste Special option again. Paste special will not function if your web browser is causing the conflict. Windows Internet Explorer (8-9) do not conflict with the Paste Special option in Excel 2010. Third party Add-ins can cause a variety of issues, one of then being, conflicting with the Paste Special option. To determine if an add-in is causing the issue:
You can also get help from the Microsoft Community online community, search for more information on Microsoft Support or Windows Help and How To, or learn more about Assisted Support options. To preview a paste option before you commit to it, click the Paste list arrow and hold the mouse over the paste option. The selected data is transposed from columns to rows. You can paste only the values as displayed in the cells, instead of the formulas that are used to calculate those values.
Excel pastes the values of the copied cell into the selected cell. Whenever you paste data, the Paste Options Smart Tag appears next to the selected cell. You can also paste values by clicking this tag and selecting a paste option from the list. You can also copy and paste cell formatting, applying formats such as a cell’s font, font size, and color to other cells.
Excel applies the formatting of the copied cell to the selected cell. If the paste commands you’re looking for aren’t available in the Paste menu, you can open the Paste Special dialog box to view advanced paste special commands.
The Paste Special dialog box displays, containing numerous paste options. The table below describes Excel's available Paste Special options. Paste Special OptionsPastePastePastes all cell contents and formatting.FormulasPastes only the formulas as entered in the formula bar.Formulas & Number FormattingPastes both the formulas as entered in the formula bar and the copied cell’s number formatting.Keep Source FormattingPastes all cell contents and formatting, including the theme, if one was applied to the source data.No BordersPastes all cell contents and formatting applied to the copied cell except borders.Keep Source Column WidthPastes the width of the source cell’s column to the destination cell’s column.TransposeChanges columns of copied data to rows, and vice versa.Paste ValuesValuesPastes only the values as displayed in the cells.Values & Number FormattingPastes both the copied cell’s values and number formatting.Values & Source FormattingPastes cell values and formatting, including the theme, if one was applied to the source data.Other Paste ValuesFormattingPastes only a cell’s formatting, the same as the Format Painter..Paste LinkLinks the pasted data to the source data by pasting a formula reference to the source data.PicturePastes a picture from your Clipboard.Linked PicturePastes a picture from a website as a link that you can click to view. How do I turn on Paste Special in Excel?To see if the Paste Special option is enabled:. Go to File > Options > Advanced.. Under Cut, copy and paste, ensure the Show Paste Options button when content is pasted option is checked.. Why I am not getting Paste Special option in Excel?Click the File tab, then click Options. , and then click Excel Options or Word Options. In the Advanced category, under Cut, copy, and paste, clear or select the Show Paste Options button when content is pasted check box to hide or display the Show Paste Options button.
How do I access Paste Special?To use options from the Paste Special box, select Home, select the clipboard icon (Paste), and select Paste Special. Keyboard Shortcut: Press Ctrl+Alt+V.
How do I activate Paste options?Turn on the Paste Options button. Go to File > Options > Advanced.. In the Cut, copy, and paste section, select Show Paste Options button when content is pasted.. Select OK.. |