To paste a URL into Excel as plain text, select the destination cell, press F2 to edit it, type an apostrophe ('), paste the URL, and press Enter. Excel uses the apostrophe to treat the entry as text and does not show the apostrophe in the finished cell. For repeated pastes, format the destination cells as Text first and check Excel’s automatic hyperlink setting.
What You’ll Need
- A workbook open in Microsoft Excel for Microsoft 365 on Windows.
- The URL you want to paste, copied as text. Copying it from the browser’s address bar is a simple way to get the address itself.
- For a batch of URLs, a selected destination range. Formatting the range as Text before you paste can help keep entries as text, but use the apostrophe method for a particular URL that Excel still converts.
You do not need an add-in or a special Excel function. If you use Excel for the web or a Mac, some menus and settings differ; those differences are noted below.
Step-by-Step
- Copy the URL as plain text. In a browser, click the address bar, press Ctrl+A to select the address, then Ctrl+C to copy it. On a Mac, use Command+A and Command+C. If you are copying a link from a webpage, use its copy-link option if available; copying linked words can bring formatting along with the address.
- Select the target cell in Excel. Click the cell where the URL should appear. If the cell already contains information, decide whether you want to replace it: pasting into a selected cell normally replaces its contents. To preserve the old value, choose a blank cell instead.
- Enter edit mode before pasting. Press F2 on Windows, or double-click the cell. The insertion point should appear inside the cell’s contents rather than just highlighting the cell. If the cell is empty, F2 puts you into edit mode for that cell; if it does not on your setup, double-click the cell and continue.
- Type an apostrophe at the start. Enter one straight apostrophe (
') as the first character. Do not type a space before it. The apostrophe tells Excel to store the following entry as text, not interpret it as a URL that should become a clickable link. - Paste the URL after the apostrophe. Press Ctrl+V on Windows or Command+V on Mac while the cell is still in edit mode. The address should follow the apostrophe in the cell editor. If the paste replaces the cell instead, undo, re-enter edit mode, and make sure the cursor is positioned after the apostrophe before pasting.
- Commit the entry. Press Enter. The apostrophe is an entry prefix and should not appear in the cell display. The URL remains visible as text, without hyperlink styling or click-to-open behavior. You can verify it by selecting the cell and checking that the formula bar shows the address as text.
- For a group of URLs, format cells as Text first. Select the destination cells, press Ctrl+1, choose Text under the Number tab, and select OK. On Mac, use Command+1 to open Format Cells. Then paste the URLs. Test with one cell first: pasted content from some sources can carry formatting, and Excel’s automatic-link behavior can vary with how the text reaches the sheet. If a URL still becomes clickable, use the apostrophe method for that entry or turn off automatic hyperlink creation as described below.
- Turn off automatic hyperlink creation if you want this behavior routinely. In Excel for Windows, go to File > Options > Proofing > AutoCorrect Options > AutoFormat As You Type. Clear Internet and network paths with hyperlinks, then choose OK in the open dialogs. This changes Excel’s automatic formatting behavior for the application, not just the current cell. On Mac, look under Excel > Settings (or Preferences) > AutoCorrect > AutoFormat As You Type; wording and availability can vary by release. Excel for the web does not provide the same desktop AutoCorrect settings, so use the apostrophe or Text-format approach there.
To remove a hyperlink that is already there: right-click the cell and choose Remove Hyperlink. The displayed URL or link text should remain, but the clickable hyperlink is removed. For a range, select the cells and look for Home > Clear > Remove Hyperlinks. If that command is unavailable in your version, use the cell’s right-click menu. Removing the hyperlink is different from deleting the cell’s contents.
Common Mistakes
- Typing the apostrophe after the URL. It must be the first character. A trailing apostrophe is just another character and does not mark the entry as text.
- Pasting while the cell is only selected. A normal paste into a selected cell can replace the whole cell. To add the apostrophe prefix and then paste, enter edit mode first and place the insertion point after the apostrophe.
- Assuming Text formatting removes an existing hyperlink. Changing a cell’s number format does not remove a hyperlink already attached to it. Use Remove Hyperlink for links that are already clickable.
- Formatting the cell after pasting and expecting the link to disappear. Text format affects how Excel handles entries; it does not reliably undo a link that has already been created. Remove the link, then re-enter the address as text if needed.
- Choosing “Clear All” by mistake. Clear All can remove contents and formatting as well as a hyperlink. Use the specific Remove Hyperlink command when you want to keep the displayed address.
- Thinking that plain text will still open when clicked. A text URL is not a clickable hyperlink. To open it, copy the displayed address and paste it into a browser. If you need both plain-text storage and convenient access, keep a separate clickable link in another column.
Tips
- Keep the raw address in its own column. For example, label column A “URL” and store the plain-text address there. This makes it easy to copy, compare, export, or process the exact text without confusing it with a friendly label such as “Product page.”
- Check how the URL looks before sharing the workbook. Long addresses can extend across blank cells or appear cut off when neighboring cells contain data. Widen the column, enable Wrap Text, or use the formula bar to inspect the full value; these display changes do not turn text into a hyperlink.
- Use a separate link column when both forms matter. Keep the address as plain text in one column and put a clickable link in another only if users need to open it directly. That way, removing or preventing a hyperlink does not make the original URL harder to retrieve.
- Be cautious with bulk pastes. A copied range may include formatting and hyperlink objects in addition to the visible text. When copying from a webpage or another workbook, try one URL first. If the result is clickable, undo and paste a plain-text version or enter the URL with the apostrophe prefix.
- Remember that the apostrophe is not part of the displayed URL. Excel uses it as an input instruction. When you select the cell, the formula bar may show the apostrophe as an indicator of text entry, but the cell itself displays the URL without it.
Troubleshooting
- The URL is still clickable. First confirm that the apostrophe was typed before the URL while editing the cell, not into a separate cell or after the address. If it was pasted from a rich webpage selection, undo and copy the address from the browser bar, then retry. You can also right-click the result and choose Remove Hyperlink, then re-enter it as text.
- The apostrophe appears in the cell. It may have been pasted as a literal character instead of entered as Excel’s text prefix. Edit the cell, remove the visible apostrophe, and type it directly in Excel before inserting the URL. Check that you are editing the cell rather than pasting a prepared string into a selected cell.
- The paste overwrites other content or lands in the wrong place. Press Ctrl+Z on Windows or Command+Z on Mac immediately. Select the intended cell again, enter edit mode, and paste only when the cursor is inside the cell editor. Check whether the source copied multiple lines or cells; if so, copy just one URL.
- The URL displays only part of its text. The cell may be too narrow, or adjacent cells may contain data that blocks the display from spilling across. Widen the column or select the cell and inspect the formula bar. The underlying text can still be complete even when the worksheet view truncates it.
- The automatic-link checkbox is missing. Check that you are in the desktop Excel app and opened AutoCorrect Options, not the ordinary cell-format dialog. The setting is in Excel’s AutoFormat As You Type options. Excel for the web has fewer settings; use the apostrophe method there instead.
Frequently Asked Questions
Will formatting a cell as Text always prevent a hyperlink?
It is useful for preparing a range, especially when entering data, but it is not a guarantee for every paste source or workflow. Pasted content can carry its own formatting, and Excel may still apply automatic formatting. For one specific URL, the apostrophe prefix is a direct way to mark the entry as text.
Does the apostrophe show in the URL?
No, when you type it as Excel’s text-entry prefix, it is not displayed in the cell. The cell shows the URL itself. If you can see an apostrophe as ordinary text, undo and enter it directly in edit mode rather than pasting it as part of the copied address.
Can I remove a hyperlink without deleting its text?
Yes. Right-click the cell and select Remove Hyperlink. This removes the clickable link while keeping the displayed text. Avoid deleting the cell or using Clear All if you need to preserve the address.
Can I paste a URL as text in Excel for the web?
Yes. Use the apostrophe method, or try formatting the destination cell as Text before pasting and confirm the result. The web app does not expose the same desktop AutoCorrect setting for turning off automatic hyperlinks, so the apostrophe is the most direct option.
Will a plain-text URL open when I click it?
No. It is stored as text rather than as a hyperlink, so clicking it selects the cell instead of opening a webpage. Copy the address into a browser, or retain a separate clickable hyperlink if workbook users need one-click access.
Does this work in Excel on Mac?
Yes. The text-entry approach is the same, but use Command+C and Command+V for copying and pasting, and Command+1 for Format Cells. AutoCorrect settings are under Excel’s Settings or Preferences, and the exact labels can differ by Mac version.
Related
- Lock an Excel Cell from Being Edited: Step-by-Step
- Keep a Zero in Front of a Number in Excel: Simple Fixes
- How to Keep Spaces Between Text When Concatenating in Excel
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Autofill in Excel From the Cell Directly AboveTo fill cells from the one above in Excel, select the source cell and the cells below it,…
- Google Sheets IF Statement Color: Change Cell ColorsAn IF formula in Google Sheets can return text or a number, but it cannot directly change a…
- How to Add a Blank Cover Page in WordTo add a blank cover page before an existing document in Microsoft Word, place the cursor at the…
- Excel Power Query: Extract Text from a StringTo extract text in Excel Power Query, select the relevant column and use Transform > Extract to choose…
- How to Create and Share a Calendar in Microsoft OutlookTo create a calendar you can share, add a separate calendar in Outlook, then use its sharing settings…
- Excel Time Picker: Ways to Choose a TimeExcel for Microsoft 365 on Windows does not include a built-in pop-up clock for choosing a time in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.