Paste Validation

This option applies the data validation rules (e.g., dropdown lists, restrictions on input) from the source cells to the target cells without affecting existing data, formulas, or formatting.

Shortcut Windows Mac
Paste Validation Ctrl Alt V , N Cmd Ctrl V , N

Download Your Complete Excel Shortcuts Cheat Sheet

Get instant access to a comprehensive PDF guide of all Excel keyboard shortcuts available on our website. Perfect for quick reference and offline use for both Mac and Windows users. Click below to download your copy and boost your productivity today!