Paste Special options

✅ Excel Paste Special – Summary with Examples

---

1. Access Paste Special

• Copy data → Ctrl + C
• Right-click on destination cell → choose Paste Special
• Or press Ctrl + Alt + V to open Paste Special dialog

---

2. Paste Options – With Examples

Option	What It Does	Example
All	Pastes formulas, formatting, comments	Cell A1 (=B1+C1, green fill) → full paste
Formulas	Pastes only the formula	A1 (=B1+C1) → pasted without green color
Values	Pastes just the result	A1 (=2+2) → pastes 4
Formats	Only pastes formatting	Green cell → destination becomes green
Comments/Notes	Pastes just notes	Adds comment bubble only
Validation	Copies dropdowns/rules	Source has dropdown → pasted cell does too
All using Source Theme	Retains font/colors from source	Matches source theme even if destination differs
All except borders	Leaves border formatting intact	Borders in destination stay unchanged
Column widths	Matches source column width	Wide source column → destination widens
Formulas + Number Format	Keeps formula + format	=B1+C1 with $ formatting → pasted together
Values + Number Format	Pasted result with %/currency	90% pastes as 90%, not 0.9
Merge Conditional Formats	Combines formatting rules	Keeps both source and destination rules

---

3. Operation Options – With Examples

Operation	Result Example
None	Regular paste
Add	10 (dest) + 5 (source) → 15
Subtract	10 − 3 → 7
Multiply	5 × 2 → 10
Divide	20 ÷ 4 → 5

---

4. Additional Features

Feature	Example
Skip Blanks	Source: A1 = 5, A2 = (blank) → Destination A2 stays unchanged
Transpose	3 vertical cells → 3 horizontal cells

---

5. Paste Special Buttons

Button	Function
Paste Link	Inserts reference like =Sheet1!A1
OK	Applies action
Cancel	Exits dialog