How to Insert an Embedded Text Box in Excel (4 Easy Ways)

In Microsoft Excel, we can insert multiple types of text boxes. But, those text boxes remain floated in the worksheet. As a result, it moves from one place to another when we insert or remove a row. In this article, we are going to demonstrate to you 4 suitable ways to insert an embedded text box in Excel. If you are also curious about it, download our practice workbook and follow us.

Table of Contents hide

Download Practice Workbook

4 Suitable Ways to Insert an Embedded Text Box in Excel

Method 1: Using Keyboard Shortcut to Insert Embedded Text Box

Method 2: Applying Text Box Feature to Insert Embedded Text Box

Method 3: Using Shapes Tools to Insert Embedded Text Box

Method 4: Running Excel VBA Code to Create Dynamic Text Box

How to Delete an Embedded Text Box in Excel

Conclusion

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

Inserting Embedded Text Box.xlsm

4 Suitable Ways to Insert an Embedded Text Box in Excel

Consider the following dataset. Let’s use this dataset to demonstrate what actions to take when an embedded text box is created. We will use the keyboard shortcuts, Text Box feature, Shapes tools, and VBA code, as well, to insert an embedded text box in Excel. Here’s an overview of the dataset for today’s task.

Method 1: Using Keyboard Shortcut to Insert Embedded Text Box

Undoubtedly, using the keyboard shortcut to insert an embedded text box in Excel is an easy and time-saving task as well. Let’s follow the instructions below to learn!

Steps:

First of all, press Alt + N + X one after one on your keyboard.
Therefore, an embedded text box pops up.
Hence, we will type any text in that embedded text box as we want.
To understand the process clearly, have a look at the below GIF .

Method 2: Applying Text Box Feature to Insert Embedded Text Box

In this section, we will learn how to create an embedded text box by applying the Text Box feature in Excel. Let’s follow the instructions below to learn!

Step 1:

To insert an embedded text box, firstly, from your Insert tab, go to,

Insert → Text → Text Box

As a result, you can create an embedded text box, and type “We use the Text Box feature.” in that text box.

Step 2:

After that, we will give the format of the embedded text box. Now, right-click on your mouse to launch the Context Menu and choose the Format Shape option.

Hence, the Format Shape window pops up. From the Format Shape window, firstly, select Shape Options. Secondly, select the Gradient fill. Hence, choose the Preset gradients you want. Further, select Radial from the Type drop-down list. Afterward, select the light pink color from the Color option.

Therefore, we will be able to give the format of the embedded text box like the below screenshot.

Method 3: Using Shapes Tools to Insert Embedded Text Box

Now, we will use the Shapes tools to insert an embedded text box. Let’s follow the instructions below to learn!

Steps:

Firstly, from your Insert tab, go to,

Insert → Illustrations → Shapes → Text Box

Therefore, you will be able to insert an embedded text box. Hence, write down any text you want. We write down “Richard Samuelson is a Lexicographer.” in that text box.

Further, we will give the format of the created embedded text box which has been done in step 2 in method 2.

Method 4: Running Excel VBA Code to Create Dynamic Text Box

Now I’ll show you how to create an embedded text box in Excel by using a simple VBA code. It’s very helpful for some particular moments. From our dataset, we will insert an embedded text box in Excel. Let’s follow the instructions below to learn!

Step 1:

First of all, open a Module, to do that, firstly, from your Developer tab, go to,

Developer → Visual Basic

After clicking on the Visual Basic ribbon, a window named Microsoft Visual Basic for Applications – Embedded Text Box will instantly appear in front of you. From that window, we will insert a module for applying our VBA code. To do that, go to,

Insert → Module

Step 2:

Hence, the Embedded Text Box module pops up. In the Embedded Text Box module, write down the below VBA code.

Sub Embedded_Text_Box()
Set Worksheet = Worksheets("VBA")
Worksheet.Shapes.AddTextbox(msoTextOrientationHorizontal, _
    100, 100, 80, 80) _
    .TextFrame.Characters.Text = "My Embedded Textbox."
End Sub

Afterward, run the VBA To do that, go to,

Run → Run Sub/UserForm

After running the VBA Code, go back to your worksheet and you will be able to see a created embedded text box, which has been given in the below screenshot.

Notes

👉 You can pop up the Microsoft Visual Basic for Applications window by pressing Alt + F11 simultaneously. You can open the Microsoft Visual Basic Applications window by using the ALT + L + V shortcut as well.

👉 If a Developer tab is not visible in your ribbon, you can make it visible. To do that, go to,

File → Option → Customize Ribbon

How to Delete an Embedded Text Box in Excel

Last but not least, we will learn how to delete an embedded text box. Let’s follow the instructions below to learn!

Steps:

Press on the edge of your embedded text box.

Therefore, press the Delete button on your keyboard.
Finally, you will be able to remove the embedded text box.

Conclusion

I hope all of the suitable examples mentioned above to insert embedded text boxes will now provoke you to apply them in your Excel spreadsheets with more productivity. You are most welcome to feel free to comment if you have any questions or queries.