Office Settings & Configuration

How to Set Unicode Text as Default Paste Option in Excel

Rana Garcia Oct 8, 2026 869 views

Question details

The user wants to configure Excel so that pressing Ctrl+V automatically pastes web content as Unicode Text without retaining the original source formatting.

How to Paste as Unicode Text by Default in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Pasting data copied from web pages or other applications into an Excel spreadsheet without bringing over unwanted fonts, colors, or background formatting.
Observed behavior: Excel retains the source formatting by default when using Ctrl+V and does not provide a standard settings menu to permanently change the default paste behavior to Unicode Text.

Before you start

Before you begin, note that Excel does not feature a built-in toggle to permanently override the default Ctrl+V shortcut to paste as Unicode Text, but you can rely on the Paste Special menu and alternative keyboard shortcuts to achieve the exact same result.

Solution 1Recommended

Use the Paste Special Menu

The standard and most reliable built-in method to strip web formatting and paste your content as clean text.

Since Excel lacks a global setting to change the default paste action, the Paste Special feature is the intended method for controlling how clipboard data is inserted into your cells.

Copy the source data

Highlight the text from your web browser or source document and press Ctrl+C to copy it to your clipboard.

Access Paste Special

Right-click the destination cell in your Excel spreadsheet where you want the data to appear, and select 'Paste Special' from the context menu.

Select Unicode Text

In the Paste Special dialog box, select 'Unicode Text' from the list of options and click 'OK'.

Preserving Special Characters: Choosing 'Unicode Text' instead of 'Text' ensures that any special symbols, foreign characters, or specific web icons are retained accurately without breaking the text encoding.

Solution 2

Use Alternative Keyboard Shortcuts

Bypass the need to click through menus by using a sequence of keyboard shortcuts to quickly paste as Unicode Text.

Work Smarter

Easily Paste Without Formatting in WPS Spreadsheet

If you are frustrated by complex formatting issues when pasting data, WPS Spreadsheet offers an incredibly intuitive and efficient way to handle clipboard text, making data entry significantly faster.

1. Download WPS Office: Install WPS Office Free and open the WPS Spreadsheet application.
2. Copy your content: Copy the text or table data from your web browser using Ctrl+C.
3. Use the right-click menu: Right-click the destination cell in WPS Spreadsheet.
4. Select Keep Text Only: Click the 'Keep Text Only' icon directly on the context menu to paste cleanly in one click.

Fully compatible with Microsoft Excel (.xlsx) and CSV formatsFeatures a highly accessible 'Paste as Unformatted Text' quick buttonLightweight, fast-loading, and completely free to useFamiliar ribbon interface requires absolutely no learning curve

microsoft office alternative - wps office

Frequently Asked Questions

Can I use an Excel macro to make Ctrl+V always paste as Unicode Text?

Yes, you can write a custom VBA macro that pastes the clipboard as Unicode Text and assign the Ctrl+V shortcut to trigger that macro. However, this overrides the default Undo functionality and requires saving your workbook as a Macro-Enabled Workbook (.xlsm).

What is the difference between 'Text' and 'Unicode Text' in the Paste Special menu?

The 'Text' option pastes data using the standard ANSI character set, which may cause complex characters or foreign languages to display as question marks. 'Unicode Text' supports a universal character set, ensuring that symbols, emojis, and non-English text render correctly.

Why does my copied web text bring a colored background into the spreadsheet?

By default, spreadsheet applications attempt to preserve the source HTML formatting, which includes background colors, font styles, and table structures. Using the Paste Special feature bypasses the HTML data and extracts only the raw characters.

Office App Problems