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.
Download Practice Workbook
Download this practice workbook to exercise while you are reading this article.
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!
- 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 .
Read More: How to Insert Text Box in Excel (5 Easy Methods)
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!
- 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.
- 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.
Read More: Formatting Text Box in Excel: All Properties to Explore
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!
- 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.
Read More: How to Edit Text Box in Excel (2 Simple Ways)
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!
- 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
- 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.
👉 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
Read More: How to Insert Scrolling Text Box in Excel (2 Ideal Examples)
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!
- 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.
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.