Paste data

To paste data from the clipboard history, follow these steps:

1.Select the place where you want to paste the data:

•If the clipboard contains data from a single cell, row or column, select the cell, row or column where you want to paste the data.

•If the clipboard contains a range of cells, rows or columns, select the appropriate size range or select the cell, row or column where you want to paste the contents of the first cell, row or column in the range.

•If the clipboard contains an object, select the cell or range to align the upper-left corner of the object with. If a range has been selected, the shape will be aligned relative to the active cell.

2.Open the content of the clipboard history in one of the following ways:

•On the Home tab, in the Edit group, click the arrow to the right of the  Paste button and select Paste from clipboard command from the drop-down list.

•When working in macOS, run the Edit > Paste from clipboard command from the command menu.

•Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu. Select the Paste from clipboard command from the context menu.

3.In the sub-menu that opens, select the data to be inserted.

You can open the content of the clipboard history in a separate window for convenience. To do this, proceed with one of the following:

–On the Home tab, in the Edit group, click the arrow to the right of the  Paste button and select the Paste from clipboard > Clipboard history command from the drop-down list.

–When working in macOS, run the Edit > Paste from clipboard > Clipboard history command from the command menu.

–Open the context menu by right-clicking any cell, headings, or the contents of any rows or columns. Select Paste from Clipboard > Clipboard History from the context menu.

–Press Ctrl+Alt+Shift+V (Windows),Win+V (Linux) or ⌥Option+⇧Shift+⌘Cmd+V (macOS).

By default, the clipboard history window is placed next to the selected or last selected cell (for example, if a column is selected). To change the window's position, drag it by the title bar while holding down the left mouse button.

When working with the clipboard history:

–You can navigate through the slots of the clipboard by pressing the ↓ and ↑ keys.

–You can paste the selected slot from the clipboard to the specified place in the document by clicking the left mouse button or pressing Enter.

–To switch between the document editing area and the clipboard window, press Tab.

To close the clipboard history window, click in the window title bar.