Which items can Excel paste selectively with the Paste Special command?

A. Formulas

B. All of the above

C. Formats

D. Validation rules

Explanation

Excel Paste Special can paste only formulas, only cell formats, or only data-validation rules. Therefore, all three listed items can be pasted selectively.

Source

Microsoft Support — Paste options

Answer verified on 2026-09-21

Found an error? Read our corrections policy and submit a sourced correction below. You can also share a useful explanation in your own words.

Discuss the answer or suggest a sourced correction
Thank you for contributing.
Your comment was submitted and will appear after editorial review.

Your email is used only for moderation and is never displayed. Spam, copied material and fabricated endorsements are rejected.