Paste Values and Formatting

ASAP Utilities › Range › 10. Paste Values and Formatting

Quickly paste both values and formatting in a single step.
This eliminates the need to use Excel's built-in Paste Special twice, once for values and once for formatting, making your workflow more efficient. 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 paste both values and formatting instantly.

Starting this tool

Click ASAP Utilities › Range › 10. Paste Values and Formatting
Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords for this tool:
Paste values and formatting together, Paste values and formats in one step, Copy values and formatting at the same time, Paste special values and formatting, Paste values and formats simultaneously, One-click paste values and formatting, Paste values and format shortcut, Paste numbers and formatting, Paste text and formatting together

Choose your language preference below

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

Paste Special with Combined Options...

Paste Values Without 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.