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.

Microsoft excel shortcut keys 2013