What is paste special in Excel?
Excel’s Paste Special provides a variety of choices to paste only particular parts of copied cells or execute a mathematical function on the copied data in circumstances where a conventional copy/paste is not acceptable.
For Example: Formula-driven data can be copied, and just the calculated values can be pasted into the same or different cells. Alternately, the copied range can be transposed, turning rows into columns and vice versa. The following screenshot shows each Paste Special option that is offered
All of the Paste Special commands work within the same worksheet as well as across different sheets and workbooks.
How to use past special in Excel?
Step-1: Prepare a data table with information outlined below
Copy Cell D2 (Select Cell D2 and press Ctrl+C)
Step-2: Select Home, select the clipboard icon (Paste) and pick the specific paste option you want, outlined below
Alternatively, you can right-click a cell where you want to paste the copied data, and then click Paste Special in the context menu., outlined below
Or you can use shortcut key for Paste Special: Ctrl+Alt+V. Paste Special dialog box will appear, outlined below
Step-2: Now select the required option from the Paste Special dialog box. See the below mentioned Excel Paste Special Shortcut Keys, Operation, and Description
Example-1 Shortcut to Paste Formulas:
- Copy Cell D2 outline in Step 1
- Select Cell D3
- Press Ctrl+Alt+V
- Select only Formula from Paste Special dialog box, outlined below
Click Ok, Result outlined below (only formula paste in cell D3
Example-2 Shortcut to Paste Values:
- Copy Cell D2 outline in Step 1
- Select Cell D3
- Press Ctrl+Alt+V
- Select only Values from Paste Special dialog box, outlined below
- Click Ok, Result outlined below (only Cell D2 value will paste in cell D3 instead of formula)
Example-3 Shortcut to Paste Formats:
- Copy Cell D2 outline in Step 1
- Select Cell D3
- Press Ctrl+Alt+V
- Select only Formats from Paste Special dialog box, outlined below
- Click Ok, Result outlined below (only Cell D2 format will paste in cell D3 instead of formula and values):
Example-4 Shortcut to Paste Comments and Notes:
Copy Cell D2 outline below (D2 include a Note)
- Select Cell D3
- Press Ctrl+Alt+V
- Select only Comments and Notes from Paste Special dialog box, outlined below
- Click Ok, Result outlined below (only Cell D2 Note or comments will paste in cell D3):
Example-5 Shortcut to Paste Validation:
- Copy Cell B2 outline below (B2 include a Data Validation)
- Select Cell B3
- Press Ctrl+Alt+V
- Select only Validation from Paste Special dialog box, outlined below
- Click Ok, Result outlined below (only Cell B2 Data Validation will paste in cell B3):
Example-6 Operation Part, Shortcut Paste to Add:
- Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)
- Select Cell D3
- Press Ctrl+Alt+V
Select only Add from Paste Special dialog box operation part, outlined below
- Click Ok, Result outlined below (Cell D2 value will add with cell D3 value):
Example-7 Operation Part, Shortcut Paste to Subtract:
- Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)
- Select Cell D3
- Press Ctrl+Alt+V
Select only Subtract from Paste Special dialog box operation part, outlined below
- Click Ok, Result outlined below (Cell D2 value will Subtract with cell D3 value):
Example-8 Operation Part, Shortcut Paste to Multiply:
- Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)
- Select Cell D3
- Press Ctrl+Alt+V
Select only Multiply from Paste Special dialog box operation part, outlined below
- Click Ok, Result outlined below (Cell D2 value will Multiply with cell D3 value):
You may be interested: