Autofill cells

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

If one cell with a text or numeric value is selected as the sample range, its contents are copied to subsequent cells when it is autofilled.

If a cell with a function is selected as the sample range, then subsequent cells are filled with data sequences calculated using this function. The values are automatically recalculated if the data in the argument cells changes.

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

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

You can autofill by dragging the corner handle or by double-clicking it.

To apply autofill with drag-and-drop, follow these steps:

1.Select one or more adjacent cells with data.

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

3.Drag the corner autofill handle over the range of cells that you want to fill in. You can drag the corner autofill handle either vertically or horizontally. When you drag the handle next to the autofill area, a tooltip will appear with the value calculated for the last cell of the progression:

If the range of cells to be filled exceeds the workspace borders, the workspace expands automatically.

When you need to autofill a progression of a few dozen cells or more, it is convenient to double-click the handle. This method will only work if there is data in adjacent cells of neighboring columns for the sample range, including corner cells.

An example of data presence in an adjacent (corner) cell of a neighboring column:

Example of missing data in adjacent cells of neighboring columns, autofill is not performed:

Autofill by double-clicking is performed only vertically down to the first empty row common to all adjacent ranges, or to the first cell with data in the column for which the autofill is applied.

A general example of autofill by double-click when there are no cells with data in the column to autofill:

A general example of autofill by double-click when there is a cells with data in the column to autofill:

To apply autofill by double-clicking, follow the steps below:

1.Select one or more adjacent cells with data.

2.Move the mouse cursor over the corner handle of the selected cell so that the cursor looks like and double-click. The automatically defined range will be filled with values.

Autofill cells with sequences with arithmetic progression

You can fill in cells with arithmetic sequences. In this type of sequence, the difference between the previous two values is added to each successive value. For example, 1, 2, 3, 4...

To autofill cells, follow these steps:

1.Enter the first 2 range values in the adjacent cells to define the sample.

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 autofill handle over the range of cells that you want to fill in. You can drag the corner autofill handle either vertically or horizontally.

Autofill cells with sequences with geometric progression

You can fill in cells with geometric sequences. In this type of sequence, each successive value is multiplied by the specified denominator of the progression. For example, 0.25, 0.5, 1, 2...

To autofill cells, follow these steps:

1.Enter the first 3 range values in the adjacent cells to define the sample.

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 autofill handle over the range of cells that you want to fill in. You can drag the corner autofill handle either vertically or horizontally.

Reduce the data range

If necessary, you can quickly reduce the range of data resulting from autofill. When the range is reduced, the data in the columns on the right or the rows on the bottom is deleted.

To reduce the range, follow the steps below:

1.Select the range of cells with the data resulting from the autofill.

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

3.If you want to delete data in the columns on the right side of the autofill range, drag the corner handle to the left. If you want to delete data in the rows at the bottom, drag the corner handle upwards.

4.Release the left mouse button. All data will be deleted from the columns or rows excluded from the range.

Cells autofill: basics

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

•A series of integers, fractions, or negative numbers.

•Dates or time.

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

•Abbreviated (Jan–Dec) or full month names (January–December).

•Abbreviated (Mon–Sun) or full weekdays names (Monday–Sunday).

•Data validation conditions.

–If the sample range contains cells of different formats, then, when autofilling a series, the cells repeat the formats and follow the sequences in the order corresponding to the sample range.

–If there is a cell with text in the sample range, it will be copied when the series is autofilled, and the other cells will follow the specified sequence.

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

–If cells hidden by a filter or manually hidden cells fall into the autofill range, they are not overwritten. The rule applies to both data and cell format and formatting.

–If the sample range contains cells hidden by filter or manually, they are not taken into account when making the progression. The rule applies to both data and cell format and formatting.

–If the sample range contains a merged cell, an identical merged cell is automatically created in the autofill range that continues the specified data sequence.

–If the sample range contains a merged cell, a part of which is hidden then autofill will not work.

–If the sample range contains a merged cell and the autofill range contains a hidden cell, the autofill will not work.

–If a merged cell partially falls into the autofill range (also due to partial hiding), the merged cell will be split.

–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 autofilling dates, the sequence is calculated based on the actual calendar difference.