AiFill Function

AIFILL() Description

The AIFILL() function is designed to fill cells with AI data directly in the Excel (Calc) worksheet.

To fill data, this function uses Google's large language model "Gemini" and can be used in any formulas, both independently and in conjunction with other standard functions.

Key Features of the AIFILL Function

Syntax:

=AIFILL(Prompt; Context)

Parameters:

• Prompt: Text that contains instructions for data generation.
• Context: A reference to cells that contain additional data.

Example of Use

Suppose you need to fill cells with certain data. You just need to enter the AIFILL() formula and specify the prompt with instructions, and Excel (Calc) will automatically generate data using AI:

=AIFILL(Prompt; {Context})

We will get the following result:

This example uses the following values:

• Prompt: B1 - Cell with text for the prompt ("Fill capital city for each country").
• Context: B5:B11 - Range of cells containing additional data ({Context}).

How It Works?

Simply enter the AIFILL() function into any cell, specifying the prompt text and the range of cells that contain additional data. After that, you need to press Ctrl+Shift+Enter to enter the array formula, and Excel (Calc) will automatically generate the data.

To select all cells associated with an array formula, simply select any cell in the array and press Ctrl+/.

If you need to convert an array formula to values - select the entire array and in the Data > Calculate menu choose Formula to Value.

Download extension

You can use the AIFILL() function by installing the YLC Utilities extension.

After this, this function will be available in all files that will be opened in Excel (LibreOffice Calc).