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.
How to Insert Scrolling Text Box in Excel: 2 Ideal Examples
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, go to the Developer tab.
- 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 Create Floating Text Box in Excel
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 Add a Dynamic Text Box in Excel
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.
Download Practice Workbook
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.
Related Articles
- How to Add Text Box in Excel Graph
- How to Put Space in Text Box in Excel
- How to Anchor Text Box in Excel
- How to Convert Text Box to Cell in Excel
- How to Remove Text Box Border in Excel
<< Go Back to TextBox | Learn Excel