The most obvious way to open the Paste Special dialog is clicking Paste > Paste Special on the Home tab, in the Clipboard group:Ģ.

You can access its features via the ribbon, right-click menu and keyboard shortcuts.

Usually, Microsoft Excel provides a numbers of ways to utilize the same feature, and Paste Special is no different. Yep, it's that simple! 3 ways to access Paste Special in Excel Select the desired paste option, and click OK or press the Enter key.Open the Paste Special dialog using one of the methods described below (the fastest way is to hit the Paste Special shortcut).Copy the source cell or a range of cells (the fastest way is to select the cell(s) and press the Ctrl + C shortcut).The use of Paste Special in Excel boils down to the following: The following screenshot demonstrates all available Paste Special options:Īll of the Paste Special commands work within the same worksheet as well as across different sheets and workbooks. Or, you can transpose the copied range, i.e. Or, you can copy the width of one column and apply it to all other columns in your data set. In situations where a standard copy / paste in not appropriate, Excel's Paste Special offers a wide range of options to paste only specific elements of the copied cells or perform a mathematical operation with the copied data.įor example, you can copy formula-driven data and paste only the calculated values in the same or different cells. Excel Paste Special is missing or not working.Copy and perform an arithmetic operation.Examples of using Paste Specials in Excel.Excel Paste Special options and shortcut keys.But did you know that apart from pasting a whole cell, you can paste only a certain attribute such as value, formula, formatting or comment? That's where Paste Special comes in.Įxcel Paste Special makes the pasting operation smoother by letting you choose which formatting (source or destination) to keep or by stripping all formatting and just pasting the values or formulas. I believe everyone knows the shortcut to copy a cell ( Ctrl+C) and to paste it ( Ctrl+V). The tutorial explains how to use Paste Special in Excel and how to make the process more efficient by using paste special shortcuts to paste values, formulas, comments, formats, column width, and more.Ĭopy pasting in Excel is easy.

Paste transpose excel shortcut mac