How can we help you?

Cut or copy the data

When you use the Cut command, the selected content is removed from the document and placed to the clipboard. When copying, the selected contents of the document do not change and their copies are placed to the clipboard.

The content copied or cut retains its formatting.

You can insert the data copied or cut into MyOffice Spreadsheet, as well as into other applications, such as MyOffice Text.

If you want to cut or copy data that contains an object (such as a shape or image), cut or copy the data and the object separately.

To cut the data, follow these steps:

1.Select the object you want to cut, or the cell, cell range, rows, or columns you want to cut the content from.

2.Run the Cut command in one of the following ways:

In the Command menu, click Edit > Cut.

On the Toolbar, select the Edit section and click t_edit_cut Cut.

Right-click the selected object, cells or the titles/contents of the selected rows/columns to open the context menu. Select Cut from the context menu.

Press Ctrl+X or Shift+Delete.

In case filters are applied or columns or rows are manually hidden, only the content of visible cells is cut.

To copy the data, follow these steps:

1.Select the object you want to copy, or the cell, cell range, rows, or columns you want to copy the content from.

2.Run the Copy command in one of the following ways:

In the Command menu, click Edit > Copy.

On the Toolbar, select the Edit section and click t_edit_copy Copy.

Right-click the selected object, cells or the titles/contents of the selected rows/columns to open the context menu. Select Copy from the context menu.

Press Ctrl+C or Ctrl+Insert.

The copied cells, rows, or columns are highlighted by a dashed line frame. The frame automatically disappears the next time you paste the copied data.

If you want to remove the dashed line frame manually, press Esc.

Paste the last cut or copied data

Pre-copied or cut out data in the clipboard is available for inserting. If a range of cells/rows/columns was copied or cut, the data will take the same size range when inserted.

Inserting data into non-empty cells or ranges deletes the previous data without warning.

You can paste data from the clipboard with or without saving the original formatting.

To insert the content while keeping its original formatting, do the following:

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.Paste the content in one of the following ways:

In the Command menu, select Edit > Paste.

On the Toolbar, select the Edit section and click t_edit_paste Paste.

On the Toolbar, select the Edit section and click the arrow to the right of the t_edit_paste Paste button. In the drop-down list, select the Paste command.

Right-click the selected cells or the titles/contents of the selected rows/columns to open the context menu and click Paste.

Press Ctrl+V or Shift+Insert.

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 insert unformatted text, 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 a text object, select the cell into which you want to paste the text.

2.Paste the content in one of the following ways:

In the Command menu, select Edit > Paste Values Only.

On the Toolbar, select the Edit section and click the arrow to the right of the t_edit_paste Paste button. In the drop-down list, select the Paste Values Only command.

Right-click the selected cells or the contents of the selected rows/columns to open the context menu and click Paste Values Only.

Paste data from the clipboard history

The clipboard history is available in MyOffice Spreadsheet. It can simultaneously store up to ten copied or cut entries. Each further entry overwrites the oldest existing entry.

The clipboard history can be used to copy and paste data from the MyOffice Spreadsheet to MyOffice Text and vice versa.

Data from the expanded clipboard is pasted while maintaining the original formatting.

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 contents of the clipboard history in one of the following ways:

Select Edit > Paste from clipboard.

Open the context menu by right-clicking the selected cells or the titles/contents of the selected rows/columns. Select Paste from clipboard.

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

To make your work easier, you can open the contents of the clipboard in a separate window. To do this, perform one of the following actions:

Select Edit > Paste from clipboard > Clipboard history.

Open the context menu by right-clicking any cell or any row/column headers/contents. Select Paste from Clipboard > Clipboard history.

Press Ctrl+Alt+Shift+V (Windows) or Win+V (Linux).

By default, the clipboard history window is placed next to the highlighted or last selected cell (for example, if a column is highlighted). 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 keys ↓ and ↑.

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

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

To close the clipboard history window, click the button wind_close the window title bar.

Clear the clipboard history

To clear the clipboard history, follow these steps:

1.Open the clipboard history sub-menu in one of the following ways:

Select Edit > Paste from clipboard.

Open the context menu by right-clicking any cell or any row/column headers/contents. Select Paste from clipboard > Clipboard history.

2.In the sub-menu that appears, select the Clear command.

Was this helpful?
Yes
No
Previous
Undo and redo