Excel is the most widely used tool for dealing with massive datasets. We can perform myriads of tasks of multiple dimensions in Excel. Sometimes we need to insert a scrolling text box in Excel. We do that whenever the text inside a box is large. This article will show how to insert a scrolling text box in Excel.
2 Examples of Inserting Scrolling Text Box in Excel
Without further ado, let’s move to the examples that I will use to show the way of inserting a scrolling text box.
1. Insert Horizontal Scrolling Text Box
The first example is the insertion of a horizontal scrolling text bar.
Steps:
- First of all, go to the Developer
- Then, select Insert.
- After that, select Text Box.
- After that, draw the text box.
- The design mode should be activated and the box should be selected.
- Next, go to Properties.
- After that, a Properties box will appear.
- Then, from the ScrollBars, activate the one for the horizontal bar.
- Then, close the properties box.
- After that, click on Design Mode to deactivate it.
- After that, write something in the box. If the length of the text exceeds the text box, a horizontal scrolling bar will appear.
Read More: How to Insert Text Box in Excel (5 Easy Methods)
2. Insert Vertical Text Box
The next example is the insertion of a vertical text box. The method is quite similar to the previous one. Let’s see the steps.
Steps:
- Bring the Properties box following the previous method.
- Then, set the MultiLine option to True.
- And, from the ScrollBars, activate the one for the vertical bar.
- Then, close the properties box.
- After that, click on Design Mode to deactivate it.
- After that, write something in the box. If the length of the text exceeds the text box, a vertical scrolling bar will appear.
Read More: How to Insert an Embedded Text Box in Excel (4 Easy Ways)
Things to Remember
- The scrolling bar will appear only if the text length exceeds the box.
- To write something in the text box, you must deactivate the design mode.
Conclusion
In this article, I have demonstrated 2 examples of inserting a scrolling text box in Excel. I hope it helps everyone. If you have any suggestions, ideas, or feedback, please feel free to comment below. Please visit Exceldemy for more useful articles like this.
Related Articles
- How to Edit Text Box in Excel (2 Simple Ways)
- Put Space in Text Box in Excel (2 Cases)
- Add Text Box in Excel Graph (2 Simple Ways)
- How to Convert Text Box to Cell in Excel (with Easy Steps)
- Formatting Text Box in Excel: All Properties to Explore
- How to Get a Text Box Linked to Cell in Excel (4 Examples)