logo ASAP Utilities
HomeExtra features for ExcelTip of the Day | Friday May 1st, 2026

Tip of the Day | Friday May 1st, 2026

Discover new tools to get things done. ASAP Utilities makes YOU rock in Excel!

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


    Range  ›  Paste Values Without Formatting

    Choose your language preference below

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

    Trustpilot
    Download  


    • Home Privacy Policy Cookie Policy EULA Download All added Excel tools Sitemap Contact Us


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