[Solved] Excel Text Box Not Showing (3 Reasons & Solutions)

Get FREE Advanced Excel Exercises with Solutions!

The text box is one of the lucrative features of Excel. Using text boxes, there are lots of advantages. We can declare anything without writing anything in the cells of Excel. It does not hamper the operation of Excel formulas. In this article, we will discuss what we need to do when the text box is not showing in Excel with proper illustrations.

3 Reasons for Text Box Not Showing in Excel and Their Solutions

There are lots of reasons why the text box is not showing in Excel. Look at the below section for details.

Reason 1: Text Box Removed from Main Tab

One of the reasons for not showing the text box, the text group is removed from the main tab. Look at the following image. The text group is missing from the Insert tab.

šŸ“Œ Solution:

  • Now, we will show how to retrieve this option.
  • Move the cursor to the main tab. Press the right button of the mouse.
  • Choose the Customize the RibbonĀ option.

  • The Excel Options window appears.
  • Choose the Main Tabs option from the Choose commands fromĀ section.

We can also avail this section from File >> Options >> Customize Ribbon.

  • Then, choose the Insert >> Text from the Main TabsĀ section.
  • Press the Add button after that.

  • Look, the Text option has been added in the InsertĀ tab.

Scroll up or down the Text option from the left-sided arrows.

  • Finally, press the OK button and look at the main tab.

We can see the Text group as well as the Text Box option in the ribbon.

Read More: How to Delete Text Box in Excel (3 Easy Ways)

Similar Readings

Reason 2: No Outline Command Makes Text Boxes Invisible

We already showed how to insert and write in a text box. The text has an outline color. If the outline color is set to No Fill. Then, the text box will not show in the dataset.

Look at the below image. We input a text in the text box but the text box border is not visible.

Text box is not visiblešŸ“Œ Solution:

  • Move the cursor around the text written in the dataset.
  • When getting to the text box, press the right button of the mouse.
  • Choose the OutlineĀ option.

Customize the outline of Excel text box

  • A color list will show. Select the desired Theme Color from this list.

  • Look at the dataset now.

The text box is visible now.

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

Reason 3: Text Box from the Shapes Menu Is Not Visible

We can also create a box like the text using the Shapes feature of Excel.

  • Go to the InsertĀ tab.
  • Choose the Shapes option from the IllustrationsĀ group
  • We select our desired shape from the list.

Insert Text box from Shapes

  • After that place the shape in the dataset.

  • Insert text inside the shape.

The text is there, but the box is not invisible.

šŸ“Œ Solution:

  • Move the cursor around the text and identify the shape.
  • Then, go to the Shape FormatĀ tab.
  • Choose Shape Outline from the Shape StylesĀ group.
  • After that, select the desired color from the list.

Customize the outline of Shapes used as text box

  • Look at the dataset.

The shape is visible and it works as the text box.

Read More: Formatting Text Box in Excel: All Properties to Explore


In this article, we described how to insert text boxes in Excel. Then we find out the reason why the text box is not showing in Excel. We also give the solution to the text box showing problem. I hope this will satisfy your needs. Please have a look at our website ExcelDemyĀ and give your suggestions in the comment box.

Related Articles

Alok Paul

Alok Paul

Hello, this is Alok. I am working as an Excel & VBA Content Developer at Exceldemy. I want to provide solutions to various Excel-based problems. I completed my study at East West University major in Telecommunications Engineering. I love traveling, reading books, playing cricket.

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF