How to Insert Text Box in Excel

- Written by Puneet

By inserting a text box in Excel, you can add text to it and move it anywhere in the worksheet. You can also customization to it by changing font style, outline, color, etc.

In this tutorial, you are going to learn all the methods to insert it and the properties and options that come with it. Let’s get started.

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 AltNX.

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, then 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