To paste text into Excel without carrying over its original formatting, copy it, select the destination cell, press Ctrl+Alt+V on Windows, choose Text or Unformatted Text if that option appears, and select OK. If Excel does not offer a text-only choice, pass the copied content through a plain-text editor such as Notepad first. This removes font styles, colors, and other rich formatting, but Excel may still interpret entries such as dates and numbers unless you prepare the destination cells as text.
The best method depends on where you copied the material from. Text copied from a webpage or Word document is different from cells copied within Excel, and pasting plain text does not always mean Excel will store every item as a text value. The steps below explain those distinctions so you can choose a method that fits the job.
What You’ll Need
- Excel for Microsoft 365 on a Windows computer, or Excel for Mac or the web if that is what you use.
- The text you want to copy and a destination cell or range in your workbook.
- For the fallback method, a plain-text editor. Notepad is included with Windows; TextEdit on Mac can be used in plain-text mode.
Step-by-Step
- Decide whether you are copying from Excel or another app. If the source is a webpage, email, PDF, Word document, or chat, use the text-only paste method in the next steps. If the source is another Excel range, see step 7: Excel’s Values paste option is usually the right choice, but it is not identical to converting values to text.
- Copy the source. Select the text or content in its original app and press
Ctrl+Con Windows. If you are copying a webpage selection, check that the selection contains only the material you need; copying an entire table can include tabs and line breaks that determine how Excel lays it out. - Select the destination in Excel. Click the cell where the pasted content should begin. If you are pasting several lines or a table, make sure there is enough clear space below and to the right. Pasted line breaks can fill additional rows, and tabs can send content into neighboring columns.
- Open Paste Special. Press
Ctrl+Alt+Von Windows. Alternatively, use Home > Paste ▼ > Paste Special. The available choices depend on the source app and the clipboard format, so your dialog may not look exactly like another computer’s. - Choose a text-only format when it is available. Select Text, Unformatted Text, or a similarly named plain-text option, then choose OK. The exact label can vary with the source and Excel build. This keeps the text content while discarding the source’s font, color, and paragraph styling. If the dialog offers no text option, cancel it and use the editor method in the next step.
- Use a plain-text editor as a fallback. Paste the copied material into Notepad, select it there, and copy it again. Return to Excel and paste into the selected cell with
Ctrl+V. Notepad strips rich formatting, so the second copy contains plain text. On a Mac, use TextEdit with Format > Make Plain Text before pasting the content into it; then copy it again and paste into Excel. - Prepare cells if you need Excel to retain text values. Before pasting, select the destination cells and choose Home > Number Format ▼ > Text. Then paste the text-only content. This is useful for values such as product codes with leading zeros or strings that look like dates. Check the results afterward: text-only paste removes formatting from the source, but it does not guarantee that Excel will interpret every entry the way you intend.
- For cells copied within Excel, paste values instead. Select the source cells, press
Ctrl+C, click the destination, pressCtrl+Alt+V, choose Values, and select OK. This replaces formulas with their current results and avoids copying the source cell formatting. It does not turn numbers or dates into text; the destination’s existing number format may still affect how values appear. - Inspect the pasted range. Check the first and last rows, column placement, line breaks, leading zeros, and any dates or long numbers. Undo immediately with
Ctrl+Zif the layout is wrong, then adjust the destination or use a different method before trying again.
Common Mistakes
Assuming Paste Values means plain text. Values paste is designed for Excel cells. It removes formulas and source formatting, but a numeric result remains a number and a date remains a date value. Use a text format on the destination, or treat the content in a plain-text editor, if you specifically need text.
Using ordinary paste and expecting source styles to disappear. A normal Ctrl+V can bring in fonts, fills, hyperlinks, and other formatting when the clipboard contains rich content. The appearance may also change later if Excel applies a table style or the destination has its own formatting, so inspect the result rather than judging only by the paste operation.
Forgetting that tabs and line breaks affect the layout. Text copied from a table often uses tabs between columns and line breaks between rows. Excel interprets those separators as instructions to fill multiple cells. That is usually helpful when importing a table, but surprising when you expected one cell to contain everything.
Overlooking automatic conversion. Plain text such as 00127 may become 127, and a string resembling a date may be converted to a date value. Formatting the destination as Text before pasting helps, but always verify important identifiers and codes after the paste.
Copying the wrong Excel option. Choosing Formulas keeps formulas rather than their displayed results, while choosing Values keeps results but not the formulas. Pick based on what you need to preserve, and do not assume either choice is a universal text-only command.
Tips
For a quick one-off paste from a browser, check the small Paste Options button that may appear beside the pasted range. Depending on the source and Excel version, it may offer Keep Text Only. This is convenient when present, but the option is not available for every clipboard type. If it does not appear, use Paste Special or the plain-text-editor fallback.
If you regularly import identifiers, postal codes, account references, or other digit strings, set the destination column to Text before importing. This helps preserve leading zeros and prevents Excel from treating the entries as numbers or dates. For a single value, typing an apostrophe before the entry, such as '00127, also tells Excel to treat it as text; Excel does not display that leading apostrophe in the cell. Avoid adding apostrophes blindly to a large pasted range, because they become part of the input process and can complicate later cleanup.
When you want to paste a whole table but remove its styling, keep the source’s rows and columns intact. A plain-text editor usually preserves tabs and line breaks while removing colors and fonts, allowing Excel to place the data in a grid. Review the preview or first few rows if your import method provides one, and leave blank cells around the destination so existing data is not overwritten.
On Windows, Ctrl+Alt+V opens Excel’s Paste Special dialog. On Mac, use Control+Command+V to open Paste Special in Excel for Mac, or use the Edit > Paste Special menu. The available formats can differ by clipboard source. Excel for the web has a more limited set of paste controls than the desktop app; when you cannot find a text-only option, use a plain-text editor and paste the cleaned content into the browser version.
Keep the original copied content available until you have checked the result. If you need to repeat the paste in several places, copy from the plain-text editor rather than repeatedly copying from the formatted source. That reduces the chance of bringing the original styling back in on a later paste.
Troubleshooting
The Paste Special dialog has no Text choice. Clipboard formats depend on the application you copied from. Close the dialog, paste into Notepad or a plain-text-mode TextEdit document, copy the content from there, and paste into Excel. For a range copied inside Excel, choose Values instead if your goal is to remove formulas and source formatting.
The content spreads across multiple cells. The copied text likely contains tabs or line breaks. If you wanted a table, this is normal; inspect the resulting columns and rows. If you wanted one cell, undo the paste and remove or replace those separators in a text editor before copying again. Alternatively, edit the text so it contains no tab or line break characters, then paste it into one cell.
Leading zeros disappear or a code becomes a date. Undo the paste, select the destination range, set Home > Number Format > Text, and paste again. If Excel has already converted the value, changing the format afterward may not restore missing zeros or the original characters; retrieve the original text and paste it again into cells already set to Text.
The pasted text still looks formatted. Check whether the destination cells already have a fill, font, or table style. Text-only paste removes formatting carried by the clipboard; it does not necessarily clear formatting already applied to the destination. To remove that existing appearance, select the cells and use Home > Clear > Clear Formats. This changes the destination formatting, so use it only if you want to remove those styles.
The paste goes to the wrong location or replaces data. Press Ctrl+Z immediately, click the intended starting cell, and confirm the destination range is clear. When pasting a multirow selection, Excel may fill adjacent cells, so avoid selecting a single cell in the middle of important data unless that layout is intended. Save the workbook before a large paste if the surrounding data is difficult to restore.
The shortcut does not open Paste Special. Confirm that Excel has focus and that content has been copied. Use the ribbon route Home > Paste > Paste Special instead. On Mac, use Control+Command+V or the Edit menu; keyboard shortcuts can vary with keyboard settings and remote desktop software.
Frequently Asked Questions
Can I paste as plain text in Excel with a keyboard shortcut?
On Windows, Ctrl+Alt+V opens Paste Special, where you can choose a text-only format if Excel offers one for the copied content. There is not one text-only shortcut that works for every clipboard source. The plain-text-editor method is a dependable fallback.
Does Paste Values remove all formatting?
It avoids copying the source cell formatting and replaces formulas with their current results, but it is not the same as plain text. The pasted result can remain a number or date, and destination formatting can still control how it appears.
How do I paste without formatting in Excel for Mac?
Use Edit > Paste Special or press Control+Command+V, then choose a text option if it is available. For content copied from an app that does not provide that option, use TextEdit in plain-text mode as an intermediary.
Can I paste plain text into Excel for the web?
Yes. Paste text copied from a plain-text editor into the selected cell or range. Excel for the web may not show the same Paste Special options as desktop Excel, and tabs or line breaks can still place content in several cells.
Why did Excel change my text into a date or remove zeros?
Excel automatically recognizes many pasted strings as numbers, dates, or other values. Set the destination cells to the Text number format before pasting, then check the result. If Excel has already changed the original characters, paste again from the source after preparing the cells.
Will plain-text paste keep hyperlinks?
Usually, a text-only paste keeps the visible words but not the rich hyperlink formatting or clickable link behavior. If you need working links, use a regular paste or copy the URL separately, then verify the link in the destination.
Related
- How to Insert a Name Line in Word
- How to Insert a Long Vertical Line in Word
- How to Insert a Manual Line Break in Microsoft Word
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Outlook Calendar Permission Levels ExplainedOutlook calendar permissions range from showing only whether you are busy to letting someone manage your calendar or…
- How to Freeze More Than the Top Row in ExcelTo freeze more than the top row in Excel, select the cell directly below the rows you want…
- Excel Cell Size in CM: What the Measurements MeanExcel does not give every cell a single size in centimeters. A cell’s width comes from its column-width…
- Create Outlook Rules to Delete Spam Messages AutomaticallyTo create an Outlook rule that deletes recurring spam, open Settings > Mail > Rules in new Outlook…
- Excel Cell Locked When Scrolling? Causes and FixesIf a cell or row stays visible while you scroll in Excel, the usual cause is Freeze Panes,…
- Invoice and Packing List Template in Excel: What to IncludeYes. An invoice and packing list template in Excel can be made as two clearly labeled worksheets in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.