Scroll bar for each cell in spreadsheet

Hi,

Please review the attached spreadsheet. We would like to insert scroll bars in each cell. (Cell A1, B1 and C1). We should be able to scroll through the text. I have tried inserting the scroll control from the developer tab but it displays only numbers.

I know that we can use the textbox control and do some changes in the properties windows so that scroll bars works, However, i would not be able to format the required text in this text box. Kindly advise. Would macro help?

Regards,
pg1533
sample.xlsx
pg1533Asked:
Who is Participating?
 
pg1533Connect With a Mentor Author Commented:
Closing this request
0
 
GeisrudSystems AdministratorCommented:
From what I've read, Excel doesn't allow for scrolling in a cell itself, you need to insert an ActiveX control to look like a cell with scrollbar.

Open the Developer tab in Excel (you may need to add that).

Click on "Insert", then from the ActiveX controls section, select "Text Box".  It looks like: ab|

Draw the area where you would like the text box to appear.

Make sure that box is selected, then click on "Properties" in the ribbon.

Set EnterKeyBehavior, MultiLine, and WordWrap to True. Set ScrollBars to 2 - fmScrollBarsVertical.

Close the Properties box then paste in your text.

Source: http://superuser.com/questions/428568/too-much-text-for-an-excel-cell-how-to-make-the-cell-scrollable

In the attached file, I've put a textbox with scrollbar in approximately cell B2 was located.
sample.xlsx
0
 
pg1533Author Commented:
Ok. I knew how to use Textbox control. I had mentioned this in the question. I would want to know if we can insert a scrollbar control in the cell which has too much text.
0
 
GeisrudSystems AdministratorCommented:
Sorry, I guess I didn't pay close enough attention to your post.  I'm not macro or VB savvy, so maybe someone else can help.
0
 
pg1533Author Commented:
didn't get the solution, hence closing the request.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.