logo ASAP Utilities

The ASAP Utilities menu in Excel (English)

Excel with ASAP Utilities in its menu

Copy Selection as Values to Clipboard

ASAP Utilities  › Export  ›  5. Copy Selection as Values to Clipboard

This tool copies the selected range as plain values to your clipboard. It provides a convenient alternative to Excel's standard Copy (Ctrl+C) when:
  • You want to copy just the values, without formulas or formatting
  • You need the copied content to remain available for pasting, even if Excel would normally reset it
  • You want to avoid issues like extra double quotes or formatting when pasting into other programs This tool helps you:
  • Copy clean values into other programs (e.g., Notepad, Outlook, web apps)
  • Avoid formatting issues when pasting into external applications
  • Skip common Excel copy quirks like automatic quote wrapping The tool works with a single continuous selection. If multiple ranges are selected, you'll be prompted to proceed with only the first one.
    The clipboard contains plain text (tab-delimited), ready to paste anywhere. Tip:
    If you want to copy only visible cells and customize how data is copied, use our "Export Selection or Sheet to New File (Excel, PDF, TXT, CSV, etc.)..." tool and choose "Copy to clipboard (tab delimited)".

    Screenshots

    Example screenshot: 1 Standard copy in Excel can cause double quotes around the data
    1 Standard copy in Excel can cause double quotes around the data
    Example screenshot: 2 The result of copying with ASAP Utilities
    2 The result of copying with ASAP Utilities

    Starting this tool


    Export  ›  5 Copy Selection as Values to Clipboard
    Additional keywords for this tool:
    copy cell values only, paste without formatting, copy clean data, clipboard plain text, avoid double quotes, Excel clipboard issues, copy without styling, Excel copy fix, values only paste, copy range to text, Excel copy workaround



  • 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 25 years, ASAP Utilities has helped users worldwide save time and do what Excel alone cannot.