How to add a text box in Excel

A Text box is also called as a text field. It is a rectangular container for the text that is used on the pages (such as web browsers, portals, word processors, log-in or registration pages, Gmail, and many more) to enter information (text).

Types of the text box

There are mainly the following two types of text boxes available with different formatting -

1. One line text box

One line text box is a simple/small box that is used to enter the single line information such as a person's name, number, email address, or other short information.

2. Multiple line text box

Multiple line text box is used to enter the large information (multiple line information) such as education details, about yourself, working experience, and many more.

Advantages of the text box

  1. text box helps us to store typed text in the linked cell.
  2. It helps you to create a large data entry spot without changing the column

Steps to Insert the Text Box in Excel

To add a text box to your worksheet, follow the below steps:

  1. First, go to the Insert tab and click on the “Text” then select “Text Box” from the ribbon.
    insert-text-textbox
  2. After that, in the Excel sheet place the cursor at the point from where you want to add the text box and drag down it by holding the left button of the mouse.
    add-text-box-in-worksheet
  3. Now, you will see the cursor inside the text box to write anything in it.
  4. Just start typing and enter the text that you want to insert.
    add-text-into-the-textbox

There’s a keyboard shortcut that you can use to insert a text box in Excel Alt ⇢ N ⇢ X.

Adding a Textbox from Shapes

  1. First, go to the Insert tab then click on “Illustrations” and then select “Shapes”.
    insert-then-illustrations-and-select-shapes
  2. Now, select the textbox from the list of shapes.
    select-text-box-from-shapes
  3. After that, click on the place in the worksheet where you want to insert it.
  4. In the end, add the text into the textbox as you want.
    text-box-with-text-is-ready

Formatting the Text Box

After adding the text box, you can change its formatting by changing its shape, font, font style, size, color, and so on. When you select the text box, you will get a new tab on the ribbon called “Shape Format”.

new-tab-shape-format-in-the-ribbon

Changing Shapes and Editing Points

There are a variety of shapes available in the drop-down of it to add the text.

insert-shapes-from-shapes-group

  • First of all, select the particular shape in which you want to add and highlight your text.
  • Then, click on the place where to want to add it.
  • After that, drag and hold the cursor to draw the same shape on the worksheet.

drag-and-hold-cursor-to-draw-same-shape

  • Now, you can enter the text of your choice in it by double-clicking.

double-click-on-shape-to-enter-text

Edit Shape – If you want to change the same shape into another, click on the edit shape drop-down arrow and select the alternative shape from the “Change Shape” option.

edit-shape-then-change-into-another

Once you click on the final shape, you will get the previous shape converted into the new one.

single-click-on-new-shape-to-convert

Edit Points – It helps you to convert the textbox into free flow. When you click on this option the existing textbox will be highlighted with small boxes. After that, click on any point from where you want to extend it in any direction.

from-edit-points-edit-text-box

Shape Styles

In the “Shape Styles” group, first, you can select the theme style of the shape in the worksheet.

select-theme-style

Even you can also choose any texture or gradient option which includes some dark and low variations of colors through “Shape Fill”.

shape-fill-options

Shape Outline allows you to change the outline color of the shape or if you want to change the width and line style of your text then click on the weight and dashes options.

shape-outline-textbox

 By “Shape Effects” you can apply some visual effects like shadow, reflection, and so on to give a different look to your text.

shape-effects-textbox

Remove the Border

For this, you have to go to the “Shape Outline” drop-down in the Shape Styles group. Then, select the “No Outline” option from it.

select-no-outline-from-shape-outline

Once you click on this, it will remove the borders of the selected shape and it looks like the below.

text-box-without-borders

Font Size, Style, and Color

Once you select the text box, you are able to add text to it just by double-clicking inside it. Many font formats are available right next to the shape styles group from where you can select the font style.

highlight-font-styles-options

Here, in the “Text Fill” option, you can change the color of the text by selecting it.

change-font-color

Text Outline and Text Effects help you modify the text by adding borders and effects to it.

text-outline-and-add-effects

Rotating the Text Box

The rotation option is on the “Arrange” group. Just click on the drop-down and you will get the sub-options of rotating the text box on the left and right by 90 degrees. Also, you can flip it horizontally or vertically.

rotate-textbox

Resizing the Text Box

It’s very easy to change the height and width of the text box. You can do it in two different ways:

  • First, once you select the text box, then you will get some small circles, and by extending these circles you can adjust their size as you want.

resize-text-box-through-small-circles

  • The second method to do this is by the size group which is on the top-right corner of the ribbon.

change-width-height-through-size-option

Conclusion

"In conclusion, the ability to insert text boxes in Excel opens up a world of creative possibilities for both enhancing the visual appeal of your spreadsheets and effectively communicating your data. Whether you're adding explanatory notes, creating professional-looking headers, or designing eye-catching callouts, text boxes provide the flexibility and customization you need to make your Excel projects truly stand out.

Remember, mastering this simple yet powerful feature empowers you to present your information in a more organized and engaging manner. By combining text boxes with other Excel functionalities, you can create dynamic reports, compelling presentations, and insightful dashboards that capture your audience's attention and deliver your message effectively.

Thank you for joining us on this journey to discover the world of text boxes in Excel. We hope this guide has equipped you with the knowledge and inspiration to take your spreadsheet skills to the next level. Stay curious, keep practicing, and remember that Excel's potential knows no bounds. Happy spreadsheet designing!"