Document Editing Problems

Fix Excel Paste Special Showing Only Unicode Text When Copying Cells

Maira Mehtab Sep 22, 2026 869 views

Question details

The user is unable to use standard Paste Special options because the dialog only displays 'Unicode Text' or 'Text', causing the loss of formulas and cell formatting during the paste operation.

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to copy a cell's formula, values, or formatting to paste it into another area of the spreadsheet using the Paste Special menu.
Observed behavior: The Paste Special dialog box is severely limited, offering only text-based pasting options (like Unicode Text) instead of the usual Excel options like Formulas, Values, and Formats.

Before you start

Make sure you are not actively typing or editing inside a cell, as Excel behaves differently when in text-edit mode compared to standard cell selection mode.

Solution 1Recommended

Copy the Cell Directly Instead of the Formula Bar

Select and copy the entire cell object to ensure Excel places the full cell data, formulas, and formatting onto the clipboard.

When you highlight and copy text directly from the formula bar (or by double-clicking inside the cell), Excel treats the copied content as a plain text string. This forces the system clipboard to only offer text-based paste options, which is why 'Unicode Text' is the only option available.

To retain all cell attributes—including background colors, underlying formulas, and number formatting—you must copy the cell as an entire object rather than just its textual contents.

Exit cell edit mode

Press the 'Esc' key or click on an empty, different cell to ensure your cursor is no longer blinking inside the formula bar or the cell itself.

Select the target cell

Click exactly once on the cell containing the data, formula, or formatting you want to copy. Ensure a solid border appears around the cell.

Copy the cell

Press 'Ctrl + C' (or 'Cmd + C' on Mac) on your keyboard, or right-click the selected cell and choose 'Copy' from the context menu.

Use Paste Special

Right-click the destination cell and select 'Paste Special'. You will now see the full suite of standard Excel paste options, such as Formulas, Values, and Formats.

Understanding Clipboard Behavior: Copying from the formula bar copies raw characters to the system clipboard. Copying the cell itself copies the underlying XML data structures specific to spreadsheet software.

Easily Copy Formulas and Formatting with WPS Spreadsheet

WPS Spreadsheet provides a highly compatible and intuitive interface for managing your data. Easily copy and paste formulas, values, and complex formatting without losing your underlying data structures.

1. Open your workbook in WPS: Launch WPS Office and open your spreadsheet file. The interface is instantly familiar.
2. Select and copy the cell: Single-click on the cell you want to duplicate and press Ctrl + C to copy the entire cell structure.
3. Apply Paste Special: Right-click the target destination cell, navigate to 'Paste Special', and choose exactly what you want to apply, such as 'Values Only' or 'Formulas'.

Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Intuitive Paste Special menu with clear, easy-to-use options for formulas, values, and formats.Lightweight, fast, and completely free to use for everyday spreadsheet tasks.Familiar user interface makes transitioning from Microsoft Office seamless.

microsoft office alternative - wps office

Frequently Asked Questions

Why do I only see 'Text' or 'Unicode Text' when pasting in Excel?

This happens when you copy data while actively editing a cell, such as double-clicking it or highlighting text directly in the formula bar at the top of the screen. Excel only copies the raw text string to your clipboard, which removes the ability to paste formulas or complex formats.

How do I paste a formula instead of its calculated value?

Ensure you single-click the cell containing the formula to select it (do not double-click), press Ctrl + C, then right-click your destination cell and choose 'Formulas' under the Paste Options or Paste Special menu.

Can I copy text from the formula bar and still keep the cell formatting?

No. Copying text directly from the formula bar will only place plain text onto your computer's clipboard. To keep the cell's background color, font styles, borders, and other formatting elements, you must single-click the cell and copy the cell itself.

Document & File Issues