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 › Range › 10. Paste Values and Formatting

Specify a Keyboard Shortcut: ASAP Utilities › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Additional keywords to help you find 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

Paste Special with Combined Options...

Tip:Alt+P for the previous tool.

Paste Values Without Formatting

Tip: Alt+N for the next tool.

Designed by Excel users for Excel users.

Practical tools many Excel users wish were built into Excel.

Save Time in Excel. The Easy Way.

ASAP Utilities helps you save time and do what Excel alone can't.

You can get started right away. No training needed.

Most users start with a few tools. Many end up using ASAP Utilities daily.

Used by teams in 28,500+ organizations.

Get Started with ASAP Utilities

Start saving time in Excel with practical tools you can use right away.

Download See What You Can Do

No sign-up required.
Free 90-day trial