Paste Special with Combined Options...

ASAP Utilities › Range › 9. Paste Special with Combined Options...

Quickly paste multiple properties at once, making it more flexible than Excel's built-in Paste Special. With Excel's default Paste Special, you can only paste one type of data at a time, such as values, formats, or comments.
This tool allows you to combine multiple paste options, such as both values and formats, in a single step, saving time and effort. How to use:
1. Copy your data range (e.g., with Ctrl+C).
2. Select the destination cell or range.
3. Run this tool to choose and apply multiple paste options at once. By default, you can launch this tool using the Control+Alt+Y shortcut.

Screenshots

Starting this tool

Click ASAP Utilities › Range › 9. Paste Special with Combined Options...
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Excel paste special formulas and formats together, Paste values and formatting simultaneously, Paste special apply formatting and values, Paste special combine values and formats, Paste values and column widths, Paste special multiple selections, Excel paste special multiple options

Choose your language preference below

English (us) ⁄ Nederlands ⁄ Deutsch ⁄ Español ⁄ Français ⁄ Português do Brasil ⁄ Italiano ⁄ Русский ⁄ 中文(简体) ⁄ 日本語

Replace Formula Errors with a Custom Message...

Paste Values and Formatting

Download

©1999-2025 ∙ ASAP Utilities ∙ A Must in Every Office BV ∙ The Netherlands

🏆 Winner of the "Best Microsoft Excel Add-in" Award at the Global Excel Summit 2025 in London!
For over 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.