Cell Autofill with Data

This option fills cells without changing source data.

To fill cells without changing source data:

Using the mouse:

Put the cursor over the square-shaped marker in the corner of the selected range's border and hold down the CTRL key. The cursor will look like:

In the web application - .
In the desktop application - .

Hold down the mouse button and move the cursor to the required table area.

Using the Autofill button in the web application or the Autofill button in the desktop application:

Put the cursor over the square-shaped marker in the corner of the selected range's border. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area. The button will appear in the corner of the obtained range:

Autofill in the web application.
Autofill in the desktop application.

Select the Copy item in the button's drop-down menu.

Copying features:

If one cell is selected, its value is copied:

In the web application:

In the desktop application:

If multiple cells are selected, their values are copied sequentially:

In the web application:

In the desktop application:

This option fills cells using linear trend.

Linear trend is a trend of time series changing described by linear equation.

To fill cells using linear trend:

Use mouse:

Put the cursor over the square-shaped marker in the corner of the selected range's border. The cursor will look as a pointer - .
Hold down the mouse button and move the cursor to the required table area.

Use the menu of the Autofill button in the web application or the Autofill button in the desktop application:

Put the cursor over the square-shaped marker in the corner of the selected range's border. The cursor will look like:

In the web application - .
In the desktop application - .

Hold down the mouse button and move the cursor to the required table area. The button appears in the bottom right corner of the obtained range:

Autofill in the web application.
Autofill in the desktop application.

Select the Fill item in the button's drop-down menu.

Fill features:

If one cell is selected, its value increases by one on autofill:

In the web application:

In the desktop application:

If multiple cells are selected, the linear trend value is calculated during autofill:

In the web application:

In the desktop application:

This option fills cells with the specified step.

To determine step value:

Apply one of the autofill options: copy or fill.
Select the Fill with Step item in the drop-down menu of the Autofill button in the web application or of the Autofill button in the desktop application. The Fill with Step dialog box opens:

In the web application:

In the desktop application:

Specify required fill step.

NOTE. Fill step value may be negative.

Features of fill with step:

If one cell is selected, its value changes by one step:

In the web application:

In the desktop application:

If multiple cells are selected, value of each cell changes by the specified step:

In the web application:

In the desktop application:

After executing autofill, the extended range is filled based on the contents of source range cells and selected autofill option. On next editing of cells in the selected range, the

Autofill button in the web application or the

Autofill button in the desktop application will be hidden. The autofill result is saved.

Cell Autofill Features

NOTE. Copying data with formatting is available only in the Reports tool. To undo copying of the mentioned parameters in a report, deselect the

Copy Formatting checkbox in the menu of the

Autofill button in the web application or the Copy Formatting checkbox in the menu of the

Autofill button in the desktop application.

In the desktop application in the table visualizer to save copied formatting, select the Use Sheet Formatting checkbox of the Parameters tab of the Table group of tabs. Otherwise, on saving or on undoing saving the copied formatting is reset.

On autofill with double-click, cells are filled from the current selected range down to the table end; if a column contains cells with already entered data, autofill is executed to these cells.

How to Determine What will be Done: Copy or Fill?

If the cursor is hovered over square-shaped marker in the corner of the selected range's border, the mouse button is held down and the user is going to stretch the range to necessary size, how to determine what will be done: copy or fill?

NOTE. If the CTRL key was held down on spreading, it is copied no matter the selected range and direction of spreading.