How to Create and Insert Auto Text Entry in Excel Office 365?
Tags: createandinsertautot, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:30:02

---
title: How to Create and Insert Auto Text Entry in Excel Office 365?
published: true
date: 2020-11-15 15:39:36 UTC
tags: CreateandInsertAutoT,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/how-to-create-and-insert-auto-text-entry-in-excel-office-365/
---

In this tutorial, we will guide you to learn the steps to **Create and Insert Auto Text Entry in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Reuse a Favorite Chart by Adding a Chart as an Auto Text Entry:

You can reuse your favorite chart by adding it as an auto text in Excel. To do this, follow the below steps.

- Go to the **Kutools Tab, select** the **Insert** option, **choose** the **Auto Text. **

![Select the Auto Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-13.png)<figcaption id="caption-attachment-17121">Select the Auto Text option</figcaption>

- It will open the **Auto Text Pane** as shown in the below image.

![Auto Text Pane](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-13.png)<figcaption id="caption-attachment-17122">Auto Text Pane</figcaption>

- Then, you need to **select the chart** that you want to save as an auto text and **click** the **Add** (+) **button** to add selected content to the auto text entry.

![Select a chart](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/11-2.png)<figcaption id="caption-attachment-17133">Select a chart</figcaption>

- It will open the **New Auto Text Dialog Box**.
- **Name box –** You need to type the name for the chart.
- **Group –** Here, you need to select a group using the given drop-down list.
- If you want to **create a new group**  for the selected group by clicking the **New group** option.

![Enter the Chart Name](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/12-2.png)<figcaption id="caption-attachment-17134">Enter the Chart Name</figcaption>

- After that, **Kutools for Excel Dialog Box** will pop-out to ask you the Group name, **enter** the **Group name** and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/13-2.png)<figcaption id="caption-attachment-17135">Click OK button</figcaption>

- Finally, **click** the **Add** button.
- You can see that the selected chart is successfully added as Auto Text entry.

![Added as auto text](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/14-2.png)<figcaption id="caption-attachment-17136">Added as auto text</figcaption>

- If you want to use this chart, you need to click on this chart in the **Auto Text pane** to insert anywhere in the workbook.
- You can also insert this chart as a picture in Excel, you need to hover the cursor on this chart and **click** the **drop-down** button, then **click** the **Insert as** option, and **select** the **picture type** from the list.

![Auto text](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/15-2.png)<figcaption id="caption-attachment-17137">Auto text</figcaption>

## Steps to Reuse a Range of Data by Adding it as an Auto Text Entry:

Here, we will see the steps to create a range of data as the Auto Text entry.

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Auto Text** to open the **Auto Text pane**.

![Select the Auto Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-13.png)<figcaption id="caption-attachment-17121">Select the Auto Text option</figcaption>

- You need to **select a range of data** that you want to add as Auto text entry.
- Then, create an Auto Text entry with the selected range by doing the below steps.
- You need to click the **Add** ( **+** ) button in the **Auto Text pane**.
- It will open the New  **Auto Text Dialog Box**.
- **Name box –** You need to type the name for the range.
- **Group –** Here, you need to select a group using the given drop-down list.
- Then, you need to **click** the **New Group** option.

![Click the Add button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/6-8.png)<figcaption id="caption-attachment-17126">Click the Add button</figcaption>

- After that, **Kutools for Excel Dialog Box** will pop-out to ask you the Group name, **enter** the **Group name** and **click** the **OK** button.

![Hit OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/7-6.png)<figcaption id="caption-attachment-17127">Hit OK button</figcaption>

- **Click** the **Add option** in the **New Auto text Dialog box**.
- Then, the selected range is added as auto text entry in the specified group.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/8-6.png)<figcaption id="caption-attachment-17128">Result</figcaption>

### To use this range as auto text, do as follows.

- If you want to **insert it as auto text** , **select** the **cell** in the worksheet to display the selected range.
- Go to the **group** and **click** on the **entry** to insert it.
- You can also **insert it as a picture**. To do this, hover the cursor on this entry and **click** the **drop-down** icon, **select** the **Insert as** option, **choose** the **Bitmap** or **Picture** **(EMF)** option from the menu.

![Insert as picture](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/9-4.png)<figcaption id="caption-attachment-17129">Insert as picture</figcaption>

## Reuse Any Formulas by Adding them as Auto Text Entries:

If you use some formulas repeatedly, then you can add them to Auto Text for using it frequently.

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Auto Text** to open the **Auto Text pane**.

![Select the Auto Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-13.png)<figcaption id="caption-attachment-17121">Select the Auto Text option</figcaption>

- After enabling the Auto Text pane, you need to **click a cell with a formula** that you want to add as an Auto Text entry.
- Now, the cell formula will display in the **Formula Bar** , you need to **select it** and then **click** the **Add** ( **+** ) button in the Auto Text pane.

![Select the formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/10-4.png)<figcaption id="caption-attachment-17131">Select the formula</figcaption>

- It will open the New  **Auto Text Dialog Box**.
- **Name box –** You need to type the name for the formula.
- **Group –** Here, you need to select a group using the given drop-down list.
- **Click** the **New group** option.

![Click the New Group option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/16-1.png)<figcaption id="caption-attachment-17138">Click the New Group option</figcaption>

- After that, **Kutools for Excel Dialog Box** will pop-out to ask you the Group name, **enter** the **Group name** and **click** the **OK** button.

![Click OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/17-1.png)<figcaption id="caption-attachment-17139">Click OK button</figcaption>

- Finally, **click** the **Add** button.
- To use this new Auto Text entry, go to the **Formulas group** in the **Auto Text** pane.
- Then, **click it** to insert it into the worksheet.
- After that, you just need to change the cell reference as you need.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/18-1.png)<figcaption id="caption-attachment-17140">Result</figcaption>

## Quickly Reuse Clip Arts/Pictures by Adding them as Auto Text:

You can also insert the clip arts or pictures as auto text in the spreadsheet. To do this, follow the below steps.

- In the way, you insert the chart, formula, and range as auto text in the worksheet, follow the same way to insert the clip arts/pictures as auto text.
- You need to follow the above steps to insert **clip arts/pictures** as auto text in Excel.

![Select Clip arts](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/19-1.png)<figcaption id="caption-attachment-17141">Select Clip arts</figcaption>

- If you want to add pictures, then **select** the **Pictures** option.

![Select Pictures](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/20-1.png)<figcaption id="caption-attachment-17142">Select Pictures</figcaption>

## Easily Transfer a Saved Auto Text Entries by Exporting/Importing Feature:

You can also transfer a saved auto text entries in Excel by doing the below steps.

- On the **Kutools Tab, select** the **Insert** option, **choose** the **Auto Text** to open the **Auto Text pane**.

![Select the Auto Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-13.png)<figcaption id="caption-attachment-17121">Select the Auto Text option</figcaption>

### Export the Auto Text entry:

- In the Auto Text pane, you need to **click** the **drop-down** button and **select** the **Export Auto Text** option.

![Select the Export Auto Text option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/21.png)<figcaption id="caption-attachment-17143">Select the Export Auto Text option</figcaption>

- It will open the **Export Auto Text dialog box** , you need to **select the group** section and check the auto text groups that you want to export, and **click** the ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-auto-text-18.png) button.
- **Select all –** It will select all the groups at the same time.
- **Inverse –** This option will reverse all selection immediately.

![Export Auto Text Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/22.png)<figcaption id="caption-attachment-17144">Export Auto Text Dialog Box</figcaption>

- Now, the **Save As dialog box** will pop-out, you need to **select the folder** for saving the auto-text and **click** the **Save** button.

![Save As Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/23.png)<figcaption id="caption-attachment-17145">Save As Dialog Box</figcaption>

- After returning to the Export Auto Text dialog box, **hit** the **OK** button.
- Then, **Kutools for Excel Dialog Box** will pop-out, you need to **click** the **OK** button.

![Click the OK button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/24.png)<figcaption id="caption-attachment-17146">Click the OK button</figcaption>

### Import the Auto Text Entry:

- In the Auto Text pane, you need to **click** the **drop-down button** and **click** the **Import Auto Text** option.

![Select Import Autotext option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/25.png)<figcaption id="caption-attachment-17148">Select Import Auto Text option</figcaption>

- It will open the Import Auto Text dialog box, click the ![](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/shot-auto-text-18.png) button.

![Click the button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/26.png)<figcaption id="caption-attachment-17149">Click the button</figcaption>

- Now, in the **Open dialog box, select** the **file** you have exported already, and **click** the **Open** button.

![Click the Open button](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/27.png)<figcaption id="caption-attachment-17150">Click the Open button</figcaption>

- If there are duplicate group names exist, a warning message will pop-out to remind you to merge the duplicate auto text group or not. You can **click Ok** or **Cancel** as you wish.

![Prompt Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/28.png)<figcaption id="caption-attachment-17151">Prompt Box</figcaption>

## Closure:

In this tutorial, you can easily understand the steps to **Create and Insert Auto Text Entry in Excel Office 365** using **Kutools. ** Leave your **queries/suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!

### Read Also:

- [Unprotect Multiple Worksheets at Once in Excel Office 365!!](https://geekexcel.com/unprotect-multiple-worksheets-at-once-in-excel-office-365/)
- [Copy Page Setup from One Worksheet to Others in Excel Office 365!](https://geekexcel.com/copy-page-setup-from-one-worksheet-to-others-in-excel-office-365/)