Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Insert Text Box in Excel (5 Easy Methods)

Sometimes we need to write a large text of multiple lines in Excel. Text boxes are very useful when it is necessary to show a large text in Excel. Moreover, text boxes can be resized and moved around easily. In this article, we will show you how to insert text box in Excel in 5 easy ways.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


5 Suitable Methods to Insert Text Box in Excel

In this article, we will demonstrate 5 easy ways to insert a text box in Excel. We will create normal text box, ActiveX Text Box as well as VBA Text Box using easy steps in the following methods.


1. Add Text Box from Insert Tab

This is the most common method to insert a text box in Excel. The procedure is discussed below.

Steps:

  • First of all, go to the Insert tab.

  • Then, click on the Text Box from the ribbon.

use Insert tab to insert text box in Excel

  • The cursor will look like a cross.

use Insert tab to insert text box in Excel

  • Now, hold the left mouse button and drag it to create a text box of your desired size.

use Insert tab to insert text box in Excel

  • Once you stop dragging, you will find the text box.

  • Now, click inside the text box and type whatever you want.

use Insert tab to insert text box in Excel

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


2. Apply Keyboard Shortcut

You can add a text box easily by using keyboard shortcuts. Follow these steps to learn the shortcut.

Steps:

  • First, press the Alt button on your keyboard to show tab shortcuts.
  • Next, you need to press the N button to open the Insert tab.

use keyboard shortcut to insert text box in Excel

  • Finally, press the X button to insert a text box.

use keyboard shortcut to insert text box in Excel

  • After pressing the X button, you will see that the text box appears in the worksheet.

use keyboard shortcut to insert text box in Excel


3. Use Shape Menu

In this method, we will use the Shapes menu to insert a text box in Excel. Read the following steps discussed below.

Steps:

  • To begin with, click on the Insert tab and then go to Shapes.
  • Then, select Text Box from the Basic shapes option.

use shape menu to insert text box in Excel

  • Next, drag your cursor to create a text box of your desired size.

use shape menu to insert text box in Excel

  • Now, you can write anything in the text box you need.

use shape menu to insert text box in Excel

Read More: How to Insert Scrolling Text Box in Excel (2 Ideal Examples)


4. Create ActiveX Text Box from Developer Tab

We will now use the Developer tab to create an ActiveX Text Box. This type of text box is very flexible to use. You can add a scrollbar in this type of text box too. Follow these steps to learn how to do it.

Steps:

  • First of all, we need to enable the Developer tab. To do that, click on the Customize Quick Access Toolbar drop-down arrow from above the Insert
  • Next, select More Commands to go to Excel Options.

  • Excel Options window will appear. Go to Customize Ribbon from there.
  • Then, check the Developer option box.
  • Press Enter and the Developer tab is enabled now.

use developer tab to insert text box in Excel

  • You will find the Developer tab above the ribbon. Click on it.
  • Next, click on Insert from the ribbon and select the Text box.

use developer tab to insert text box in Excel

  • Now, drag your cursor to create a text box.

use developer tab to insert text box in Excel

  • This type of text box has the Design Mode enabled by default. We need to switch off this mode and enable the Type Mode.
  • To do it, once the text box is created, right-click on it.
  • Then, select TextBox Object and click on Edit.

use developer tab to insert text box in Excel

  • You will find that the Type Mode is enabled now and you can type your desired text in there.

use developer tab to insert text box in Excel

  • Now, we want to add a scrollbar in our text box.
  • For this purpose, right-click on the text box and select Properties.

  • Change the Multiline option from False to True. It will allow multiline text in the text box.
  • Then, change the ScrollBars option to 2-fmScrollBarsVertical to add a vertical scrollbar.

  • Now if you look at your text box, you will find a scrollbar on the right side.

use developer tab to insert text box in Excel

Read More: How to Edit Text Box in Excel (2 Simple Ways)


5. Insert VBA Text Box

Now you will see how to insert a VBA Text Box in Excel. Keep on reading to learn the steps.

Steps:

  • In the beginning, press Alt+F11 to open the Microsoft Visual Basic window.
  • Next, click on Insert and select UserForm.

  • A UserForm window will appear with a Toolbox.
  • Now, click the Text Box option in the Toolbox.

how to insert VBA text box in Excel

  • Then, go to the UserForm and drag your cursor to insert a text box.

how to insert VBA text box in Excel

  • Once you stop dragging, a text box will be created and you will be able to type any text in the text box.

how to insert VBA text box in Excel

Read More: How to Add Text Box in Excel Graph (2 Simple Ways)


How to Create Input Box in Excel

We will now create an Input Box in Excel. We will run a VBA code for this purpose. Follow these steps to create and run a VBA code to create an input box.

Steps:

  • First of all, go to the Microsoft Visual Basic window by pressing Alt+F11.
  • Next, in the Microsoft Visual Basic window, select Module in the Insert tab.

  • Now, we will write a VBA code in the module.
  • In the code, we will use the InputBox You can type your preferred Prompt, Title, Default inside it.

how to create input box in Excel

  • Then, you can add your preferred location where you want the text. For this purpose, we used the Range
  • For instance, we chose B5 cell as the location, “Enter Your Company Name” as the Prompt.
  • Additionally, we wrote “Enter Name” as the Title and “For Example: SOFTEKO” as Default The VBA code is given below.
Sub Create_Input_Box()
 Range(B5) = InputBox("Enter Your Company Name", "Enter Name", "For Example: SOFTEKO") 
End Sub

how to create input box in Excel

  • Finally, press F5 to run the code and go back to your worksheet.
  • You will find an input box there. Write what you want in the input box and press OK.

how to create input box in Excel

  • The text will appear in cell B5.


Things to Remember

  • After creating an ActiveX Text Box, you need to disable the Design Mode first to write any text in the box.
  • If you already have the Developer tab in your worksheet, you don’t need to enable it.

Conclusion

Thanks for making it this far. I hope you find this article useful. Now you know 5 easy ways to insert a text box in Excel. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.


Related Articles

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo