Skip to main content

How to use the GPT function

Learn how to write and lay out your prompts and your data in Microsoft Excel in order to use the GPT function efficiently, from a simple prompt up to running multiple prompts in parallel on a column of data. The concepts and steps covered in this article apply to most functions in GPT for Excel. Although the examples on this page use Google Sheets, the formulas and functionality work similarly in Excel.

Prerequisites
Create a Microsoft workbook and click GPT for Excel Word in the Home tab.
You can use the example template to follow along.

Types of prompts

Write your prompt in the function

Type a GPT formula into a cell and press Enter to generate the result:

Type '=GPT('Write a tagline for a car')' in cell C12

See it in action in this video:

Use a cell as a prompt

Type a prompt in a cell and use this cell as a parameter for your formula:

Type '=GPT(A16)' in cell D16

See it in action in this video:

Apply a prompt to many cells

Apply a simple prompt to many cells

Separate the prompt from the value it applies to: "prompt",A25. Then drag the formula down to apply it to other values:

Type '=GPT('Write a tagline',A25)' in cell C25 then drag the cell over C26 to C28

See it in action in this video:

Apply a cell prompt to many cells

Use a $ symbol to create an absolute reference to the cell used as a prompt. The reference to the cell won't change when you drag the formula down the column:

Type '=GPT($A$32,B33)' in cell D33 then drag the cell over D34 to D35

See it in action in this video:

Use more data in your prompt

Build a complex prompt

Enter a GPT formula with a range of cells as a parameter:

Type '=GPT(A41:B46) in cell E41

See it in action in this video:

Apply a complex prompt to many cells

Enter a GPT formula with a range of cells as a parameter, and use a $ symbol to create an absolute reference to the cells used as a prompt. The reference to the cells won't change when you drag the formula down the column:

Type '=GPT($A$50,$B$54)' in cell E51 then drag the cell over E52 to E53

See it in action in this video:



What's next

Now that you are familiar with the basics of GPT formula creation, try out our examples involving various functions.