Paste Values Without Formatting

ASAP Utilities › Range › 11. Paste Values Without Formatting

Quickly paste copied data as values without carrying over formulas or formatting.
This tool lets you paste only the actual values while keeping the format of the destination cells unchanged.

This is useful when you:

Need to prevent formatting changes when pasting into a formatted table.
Copy data from external sources and want to paste it as plain text into Excel.

It saves time compared to using Excel's "Paste Special > Values" option, allowing you to paste values instantly in one step.

For even faster access, assign a custom shortcut via "My Tools & Shortcuts".

Historical Note:
ASAP Utilities introduced this tool in 2012, a decade before Excel added Control+Shift+V for the same purpose in 2022.

Starting this tool

Click › Range › 11. Paste Values Without Formatting

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

Additional keywords to help you find this tool:
Excel paste values without formatting, Paste values only, Paste as plain text, Paste values without changing formatting, Paste values only shortcut, Paste values shortcut, Paste values only command

Paste Values and Formatting

Tip:Alt+P for the previous tool.

Copy Visible Cells and Paste to Visible Cells in Target Range...

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