To find out what a particular icon does, hover over it. If you start hovering over the Paste Special... item in the context menu, a fly-out menu will show up offering 14 more paste options: Paste Special command in the right-click menuĪlternatively, you can right-click a cell where you want to paste the copied data, and then click Paste Special in the context menu.Īs you may have noticed, 6 most popular paste options appear directly in the pop-up menu, under Paste Options: paste everything (equivalent of CTRL + V), paste values, paste formulas, transpose, paste formatting, and paste link: 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
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.
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.