How to Paste Special Shortcuts in Excel

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

Paste special

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

Paste special

 

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

Paste Special

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

Paste special

Or you can use shortcut key for Paste Special: Ctrl+Alt+V. Paste Special dialog box will appear, outlined below

Paste special

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

Paste Special

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

paste Special

Click Ok, Result outlined below (only formula paste in cell D3

Paste special

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

Paste special

  • Click Ok, Result outlined below (only Cell D2 value will paste in cell D3 instead of formula)

Paste special

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

Paste special

  • Click Ok, Result outlined below (only Cell D2 format will paste in cell D3 instead of formula and values):

Paste special

Example-4 Shortcut to Paste Comments and Notes:

Copy Cell D2 outline below (D2 include a Note)

Paste special

  • Select Cell D3
  • Press Ctrl+Alt+V
  • Select only Comments and Notes from Paste Special dialog box, outlined below

Paste special

  • Click Ok, Result outlined below (only Cell D2 Note or comments will paste in cell D3):

Paste special

Example-5 Shortcut to Paste Validation:

  • Copy Cell B2 outline below (B2 include a Data Validation)

Paste special

  • Select Cell B3
  • Press Ctrl+Alt+V
  • Select only Validation from Paste Special dialog box, outlined below

Paste Special

  • Click Ok, Result outlined below (only Cell B2 Data Validation will paste in cell B3):

Paste Special

Example-6 Operation Part, Shortcut Paste to Add:

  • Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)

Paste Special

  • Select Cell D3
  • Press Ctrl+Alt+V

Select only Add from Paste Special dialog box operation part, outlined below

Paste Special

  • Click Ok, Result outlined below (Cell D2 value will add with cell D3 value):

Paste Special

Example-7 Operation Part, Shortcut Paste to Subtract:

  • Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)

Paste Special

  • Select Cell D3
  • Press Ctrl+Alt+V

Select only Subtract from Paste Special dialog box operation part, outlined below

Paste Special

  • Click Ok, Result outlined below (Cell D2 value will Subtract with cell D3 value):

Paste Special

Example-8 Operation Part, Shortcut Paste to Multiply:

  • Copy Cell D2 outline below (D2 have only value 500 and D3 have value 300)

Paste special

  • Select Cell D3
  • Press Ctrl+Alt+V

Select only Multiply from Paste Special dialog box operation part, outlined below

Paste Special

  • Click Ok, Result outlined below (Cell D2 value will Multiply with cell D3 value):

You may be interested:

  1. Financial Dashboards
  2. Sales Dashboards
  3. HR Dashboards

 

Leave a Comment

Your email address will not be published. Required fields are marked *

Categories