Skip to main content

Paste data without preserving the original formatting

The following rules apply when pasting data without preserving the original formatting:

  • Only the text is pasted from the clipboard. For example, when you paste a shape with text or a link, only the text that these objects contain is pasted into the document.
  • If the clipboard contains a formula, only the result of the formula is pasted.

To paste data without the original formatting, follow the steps below:

  1. Select the place where you want to paste the data:
    • If the clipboard contains data from a single cell/row/column, select the cell/row/column where you want to paste the data.
    • If the clipboard contains a range of cells/rows/columns, select the appropriate size range or select the cell/row/column where you want to paste the contents of the first cell/row/column in the range.

•If the clipboard contains an object with text, select the cell into which you want to paste the text.

  1. Run the Paste command in one of the following ways:
    • On the Home tab, in the Edit group, click the arrow to the right of the t_home_paste Paste button. In the drop-down list, select Values only.
    • Right-click the selected cells or the contents of the selected rows/columns to open the context menu. Select Paste special > Values only.
    • Open the context menu by right-clicking on the headers of the selected rows or columns. Run the Values only command from the context menu..
    • Press Alt+Shift+V.