How can we help you?
Product:
Application: Table Desktop version

Cut or copy data

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

The data is cut and copied while maintaining 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 Edit menu, select Cut.

On the Toolbar, in the Edit section, 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 Edit menu, select Copy.

On the Toolbar, in the Edit section, 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

You can paste previously copied or cut data from the clipboard. 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. To retain existing data, use shift cell insertion.

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

To paste data while maintaining 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.

The first cell for rows is the leftmost cell, for columns is the top cell, and for ranges is the leftmost top cell.

If the clipboard contains an object, select the cell to align the upper left corner of the object to.

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

In the Edit menu, select Paste.

On the Toolbar, in the Edit section, 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 Paste.

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

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 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.

The first cell for rows is the leftmost cell, for columns is the top cell, and for ranges is the leftmost top cell.

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

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

In the Edit menu, select 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 Paste Values Only.

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

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.

The data from the clipboard history is pasted with the original formatting preserved.

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.

The first cell for rows is the leftmost cell, for columns is the top cell, and for ranges is the leftmost top cell.

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:

In the Edit menu, select Paste from Clipboard.

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:

In the Edit menu, select Paste from Clipboard > Clipboard History.

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) or Win+V (Linux).

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 wind_close in 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:

In the Edit menu, select Paste from Clipboard.

Open the context menu by right-clicking any cell or titles/contents of any rows/columns. In the context menu, select Paste from Clipboard.

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

Was this helpful?
Yes
No
Previous
Undo and redo