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.

In some cases, a formula or number that is entered into a cell needs to be retained in its original form. For example, display zero characters when entering the number 00056 or specify a formula without its further use. To do this, the cell with the number or formula should be formatted as Text.

The formatting is applied by using a single quotation mark ('). The single quotation mark should be entered in a cell immediately before the formula or number to be recognized as text. For example: '=SUM(B1;C1) or '00056.

The quotation mark is displayed:

•In the formula bar, when you select a cell.

•In the cell and in the formula bar, when you edit a cell.

If you want to cancel text formatting, delete the quotation mark in the cell.