How to Insert a Text Box in Excel – 5 Methods

Method 1 – Add a Text Box using the Insert Tab

Steps:

  • Go to the Insert tab.

  • Click Text Box..

use Insert tab to insert text box in Excel

  • The cursor will show a cross.

use Insert tab to insert text box in Excel

  • Left- click and drag the cursor to create a text box.

use Insert tab to insert text box in Excel

This is the output.

  • Click inside the text box to enter text.

use Insert tab to insert text box in Excel


Method 2 – Applying a Keyboard Shortcut

Steps:

  • Press Alt.
  • Press N to open the Insert tab.

use keyboard shortcut to insert text box in Excel

  • Press X to insert a text box.

use keyboard shortcut to insert text box in Excel

The text box is created.

use keyboard shortcut to insert text box in Excel

Read More: How to Get a Text Box Linked to Cell in Excel


Method 3 – Using the Shape Menu

Steps:

  • Click Insert and go to Shapes.
  • Select Text Box in Basic Shapes.

use shape menu to insert text box in Excel

  • Drag your cursor to create a text box.

use shape menu to insert text box in Excel

  • Enter your text.

use shape menu to insert text box in Excel

Read More: How to Link Textbox to Multiple Cells in Excel


Method 4 – Create an ActiveX Text Box using the Developer Tab

Steps:

  • Enable the Developer tab: click Customize Quick Access Toolbar.
  • Select More Commands to go to Excel Options.

  • Select Customize Ribbon.
  • Check Developer.
  • Press Enter.

use developer tab to insert text box in Excel

  • Click the Developer tab.
  • Choose Insert and select Text box.

use developer tab to insert text box in Excel

  • Drag your cursor to create a text box.

use developer tab to insert text box in Excel

  • The Design Mode is enabled by default. Enable the Type Mode.
  • Right-click the text box.
  • Select TextBox Object and click Edit.

use developer tab to insert text box in Excel

  • The Type Mode is enabled.
  • Enter your text.

use developer tab to insert text box in Excel

  • To add a scrollbar to the text box, right-click it and select Properties.

  • Change Multiline to True.
  • Change the ScrollBars option to 2-fmScrollBarsVertical to add a vertical scrollbar.

A scrollbar will be displayed.

use developer tab to insert text box in Excel

Read More: How to Edit Text Box in Excel


Method 5 – Insert a Text Box with VBA

Steps:

  • Press Alt+F11 to open the Microsoft Visual Basic window.
  • Click Insert and select UserForm.

  • A UserForm window will be displayed.
  • Click Text Box in the Toolbox.

how to insert VBA text box in Excel

  • Go to the UserForm and drag your cursor to insert a text box.

how to insert VBA text box in Excel

The text box is created, and you will be able to enter your text.

how to insert VBA text box in Excel


How to Create an Input Box in Excel

Steps:

  • Go to the Microsoft Visual Basic window by pressing Alt+F11.
  • Select Module in the Insert tab.

 

  • Enter the the code:

how to create input box in Excel

  • You can add the location to see the text. Here, Range
  • B5 is the location, “Enter Your Company Name” is the Prompt.
  • “Enter Name” is the Title and “For Example: SOFTEKO” is used as Default.
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

  • Press F5 to run the code and go back to your worksheet.
  • An input box is displayed. Enter data and click OK.

how to create input box in Excel

The text will be displayed in B5.


Download Practice Workbook

Download the practice workbook.


 

Related Articles


<< Go Back to TextBox | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Alif Bin Hussain
Alif Bin Hussain

Alif Bin Hussain earned a BSc in Civil Engineering from Bangladesh University of Engineering and Technology. As an engineering graduate, he has a deep passion for research and innovation. He loves to play with Excel. In his role as an Excel & VBA Content Developer at ExcelDemy, he not only solves tricky problems but also shows enthusiasm and expertise in handling tough situations with finesse, emphasizing his dedication to delivering top-notch content. He is interested in C, C++,... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo