Formatting Issues

How to Paste Website Text into Excel with Consistent Formatting

Natalie Taylor Oct 9, 2026 869 views

Question details

The user frequently pastes text and URLs from web browsers into Microsoft Excel and wants the pasted content to automatically adopt the spreadsheet's existing font and size.

How to Paste Website Text into Excel with Consistent Formatting

Product: Microsoft 365 Excel
Device & OS: not provided
Scenario: Copying text or web addresses from online sources and pasting them into an Excel spreadsheet without carrying over the original HTML formatting.
Observed behavior: Pasted text retains the original website formatting and hyperlink styles instead of matching the destination cell's font and size.

Before you start

Ensure that the destination cells in your Excel spreadsheet are already formatted with your desired font style, size, and alignment before you begin pasting the web content.

Solution 1Recommended

Use Match Destination Formatting

This is the most straightforward method to paste content without bringing over the website's HTML styling, allowing the text to adopt your Excel sheet's formatting.

While Microsoft 365 Excel does not have a built-in global setting to make this the default paste action, using the built-in paste options menu is the fastest way to achieve consistent formatting without writing code.

Copy web text

Highlight the text or URL on the website and press Ctrl + C to copy it to your clipboard.

Select the target cell

Open your Microsoft 365 Excel workbook and right-click the cell where you want to paste the information.

Choose the matching paste option

Under the 'Paste Options' section in the right-click context menu, click the icon for 'Match Destination Formatting' (typically represented by a clipboard with an arrow and the letter 'M').

Keyboard Shortcut Tip: Alternatively, you can paste using Ctrl + V, immediately tap the Ctrl key to open the Paste Options menu, and then press the M key on your keyboard.

Solution 2

Create a Custom Macro for Unformatted Pasting

If you perform this action frequently, you can create a simple VBA macro and assign it a custom keyboard shortcut to automate pasting as plain text.

Efficient Spreadsheet Formatting

Easily Paste Unformatted Web Text in WPS Spreadsheet

WPS Spreadsheet makes it simple to paste website text and URLs while automatically matching your document's formatting. You can quickly use Paste Special features to keep your datasets clean and professional.

1. Format your document: Open your workbook in WPS Spreadsheet and apply your preferred font, size, and borders to the target cells.
2. Copy the source text: Highlight and copy the desired text or URLs from your web browser.
3. Access Paste Special: Right-click the destination cell in your WPS Spreadsheet and select 'Paste Special' from the context menu.
4. Select Unformatted Text: Choose 'Unformatted Text' or 'Match Destination Formatting' to paste the data perfectly into your existing cell style.

Easily paste web data as unformatted text with quick context menusFully compatible with Microsoft Excel (.xlsx and .xls) file formatsLightweight application with intuitive cell formatting toolsFree to use across Windows, Mac, Linux, iOS, and Android platforms

microsoft office alternative - wps office

Frequently Asked Questions

Can I set 'Match Destination Formatting' as the absolute default paste option in Microsoft 365 Excel?

Currently, Microsoft 365 Excel does not offer a built-in global setting to permanently change the default Ctrl+V behavior to 'Match Destination Formatting'. You must use the Paste Options menu manually, or set up a VBA macro with a custom shortcut.

Why do URLs pasted into Excel retain their blue underlined formatting?

Web browsers copy URLs as rich HTML links by default. Excel respects this rich text clipboard data and retains the hyperlink formatting unless you specifically intervene by choosing to paste as plain text or matching the destination formatting.

How can I remove website formatting from data I've already pasted into Excel?

If you have already pasted the data and it ruined your formatting, select the affected cells, navigate to the Home tab, click the 'Clear' dropdown (represented by a pink eraser icon), and choose 'Clear Formats'. This will revert the text to the default Excel cell style.

Is it possible to add the 'Paste as Text' button to the Quick Access Toolbar?

Yes. You can go to File > Options > Quick Access Toolbar. Under 'Choose commands from', select 'All Commands', scroll down to find 'Paste and Match Destination Formatting' (or 'Paste as Text'), and click 'Add' to place it on your toolbar for easy one-click access.

Document & File Issues