How to Insert Scrolling Text Box in Excel (2 Ideal Examples)

Get FREE Advanced Excel Exercises with Solutions!

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.

Insert Scrolling Text Box in Excel

  • After that, draw the text box.

  • The design mode should be activated, and the box should be selected.

How to Insert Horizontal Scrolling Text Box in Excel

  • Next, go to Properties.

  • After that, a Properties box will appear.
  • Then, from the ScrollBars, activate the one for the horizontal bar.

How to Insert Horizontal Scrolling Text Box in Excel

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

How to Insert Horizontal Scrolling Text Box in Excel

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.

How to Insert Vertical Scrolling Text Box in Excel

  • After that, write something in the box. If the length of the text exceeds the text box, a vertical scrolling bar will appear.

Insert Scrolling Text Box in Excel

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


<< Go Back to TextBox | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Akib Bin Rashid
Akib Bin Rashid

AKIB BIN RASHID, a materials and metallurgical engineer, is passionate about delving into Excel and VBA programming. To him, programming is a valuable time-saving tool for managing data, files, and internet-related tasks. Proficient in MS Office, AutoCAD, Excel, and VBA, he goes beyond the fundamentals. Holding a B.Sc in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, MD AKIB has transitioned into a content development role. Specializing in creating technical content centred around Excel and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo