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/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, select the cell to align the upper left corner of the object to.

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 in the drop-down list, hover the cursor over Paste from clipboard command.

•When working in macOS, select 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. In the context menu, select Paste from clipboard.

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 then select Paste from clipboard > Clipboard history command.

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

•Open the context menu by right-clicking any cell or titles/contents of any rows/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.