Enter data

To enter or change data in a cell, follow these steps:

1.Activate the edit mode in one of the following ways:

•Select an empty cell.

•Double-click the cell you want to edit.

•Select the cell you want to edit and go to the Formula bar.

2. Enter data into the cell.

3. Save the entered data in one of the following ways:

•Press Enter.

•Click on the right side of the Formula bar.

•Select another cell on the spreadsheet.

To undo the changes you have made, do one of the following while editing:

•On the right side of the Formula bar, click .

•Press Esc.

When you enter a number in a cell, the width of this cell is automatically adjusted to fit the number.

Cells width is not adjusted in the following cases:

•The width of the column containing the cell has been previously changed manually.

•The cell format is Text.

•The cell is filled with text.

The floating cell appears when you edit a cell and move through the current sheet of the spreadsheet. The cell displays the current data in the cell you were editing, so it is convenient to use when navigating through a large amount of data in the document.

MyOffice Spreadsheet allows to automatically fill the adjacent cells. A single cell as well as a range of cells can be selected as a sample for filling.

If a single cell with a text or numeric value is selected as a reference, its content is copied to subsequent cells when it is autofilled.

If a cell with a formula is selected as a reference, the subsequent cells will be filled in with data sequences calculated using the formula specified in the cell. The values are automatically recalculated if the data in the formula cells change.

If a cell range is selected as a sample range, the subsequent cells are filled in according to the rules described below.

The filled cells will have the same format as the sample range.

To fill the cells automatically, follow these steps:

1.Enter data in one or multiple cells.

2.Select the cells.

3.Move the mouse cursor over the corner handle of the selected cell so that the cursor looks like .

4.Drag the corner autofill handle over the range of cells that you want to fill in. You can drag the corner autofill handle vertically or horizontally.

Fill cells automatically with arithmetic sequences

You can fill in cells with arithmetic sequences. This type of sequence adds the difference between the previous two to each of the subsequent values. For example, 1, 2, 3, 4.

To autofill cells with an arithmetic sequence, follow these steps:

1.Enter the first 2 range values in the adjacent cells to set the reference.

2.Select the resulting range.

3.Move the mouse cursor over the corner handle of the selected cell so that the cursor looks like .

4.Drag the corner fill handle over the range of cells that you want to fill in.

Fill cells automatically with geometric sequences

You can fill in cells with geometric sequence. In this sequence view, each of the following values is multiplied by the specified progression denominator. For example, 0.25, 0.5, 1, 2.

To autofill cells with a geometric sequence, follow these steps:

1.Enter the first 3 range values in the adjacent cells to set the reference.

2.Select the resulting range.

3.Move the mouse cursor over the corner handle of the selected cell so that the cursor looks like .

4.Drag the corner fill handle over the range of cells that you want to fill in.

Autofill cells with data sequences: basics

•Cells can be filled automatically if two or more cells from the sample range contain the following data:

oA series of integers, fractions, or negative numbers.

oDates or time.

oText and a number (with or without the delimiter). For example, Text 1, Text 2 or Text1, Text3, Text5.

oAbbreviated (Jan-Dec) or full month names (January-December).

oAbbreviated (Mon-Sun) or full weekdays names (Monday-Sunday).

•If there is a text cell in the reference range, it will be copied when the series is filled automatically, whereas other cells will follow the specified sequence.

•If a text cell is located between cells in a series that have different formats, the text will be copied when filling automatically, and cells of different formats will follow different sequences.

•Cells of General and Number formats (Number, Currency, Accounting, Fraction, Percentage, Scientific) are considered as one sequence.

•Date and Time are unrelated formats and are considered as separate sequences.

•When filling with dates, the sequence is calculated based on the actual calendar difference.

You can insert the current date or time anywhere in the document.

To insert the current date, follow these steps:

1.Place the cursor where you want to insert the current date.

2.Insert the date in one of the following ways:

•In the Command menu, select Insert > Current Date.

•On the Toolbar, select the Insert section and click . In the insert pane that appears, click Date.

To insert the current time, follow these steps:

1.Place the cursor where you want to insert the current time.

2.Insert the time in one of the following ways:

•In the Command menu, select Insert > Current Time.

•On the Toolbar, select the Insert section and click . In the insert pane that appears, click Time.

When you use the Cut command, the selected content is removed from the selected cell/row/column 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 into MyOffice Spreadsheet, as well as into other applications, such as MyOffice Text.

To cut the content of the file, follow these steps:

1.Select a cell, a range of cells, 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 Cut.

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

•Press Cmd+X.

To copy the content of the file, follow these steps:

1.Select a cell, a range of cells, 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 Copy.

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

•Press Cmd+C.

The copied data is 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.

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.

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.

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

•On the Toolbar, select the Edit section and click the arrow to the right of the 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 Cmd+V.

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 hyperlink, only the text that these objects contain is pasted into the document.

•If the copied or cut fragment contains images, they are not 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.

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

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.

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 Option+ Shift+ Cmd+V.

By default, the expanded clipboard window is placed next to the highlighted or last selected cell (for example, if a column is highlighted). To change its location, drag it to the desired part of the sheet 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 the window title bar.

Clear the clipboard history

To clear the clipboard history, follow these steps:

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

To delete the contents of a cell, do the following:

1.Select a cell or a range of cells that you want to clear.

2.Press Delete.