1
 |
Chewits   United Kingdom. Mar 06 2011 18:18. Posts 2539 | | |
Any excel pros help me out here?
Basically I want to be able to put scroll bars into a single cell. I have a database that in certain sections, a cell has lots and lots of text, and does not fit visibly on the cell. So I want to be able to have a scroll bar to scroll through all the text in that single cell.
I suck at googling and not having much joy so far.
Cheers
|
|
I am a degen. Do not believe in any of my advice. | |
|
|
1
 |
Critterer   United Kingdom. Mar 06 2011 22:18. Posts 5337 | | |
i dont know how to do this, but why are you writing lots and lots of text in a single cell though?
also can u not just look in the formula bar, you can scroll through there. |
|
LudaHid: dam.ned dam.ned dam.ned. LudaHid: dam.ned northwooden as..hole | |
|
|
1
 |
Chewits   United Kingdom. Mar 07 2011 04:47. Posts 2539 | | |
Because the cell is linked with the rest of the row, and if i want to filter by other things in other cells in that row, if its over 2 cells down it gets messed up. (I can go wide. There may be quite a few lines of text in the cell. |
|
I am a degen. Do not believe in any of my advice. | |
|
|
1
 |
Rolon   Netherlands. Mar 07 2011 09:15. Posts 229 | | |
basically not possible, u may get it somehow writing it in VBA and/or creating textboxes, but you would still have a hard time getting it to work properly with the rest of the sheet. if you really wish to do it anyway, i would work with some additional sheets and redirect to them |
|
|
|
1
 |
hhse   Australia. Mar 09 2011 20:23. Posts 213 | | |
(1) Make the cell bigger
(2) Hyperlink the cell to a different worksheet and put the text there, and put a hyperlink back to main page.
(3) Change it into a comment so when you high-light cell, the text pops up as a comment.
(4) If the text is further characteristics, i.e black, tall, smooth etc, split add three additional columns for each category etc...
I can't say I've seen a scroll bar within a cell. |
|
|
1
 |
Chewits   United Kingdom. Mar 09 2011 20:32. Posts 2539 | | |
Thanks. I worked out a work around for my specific problem. But yeah you cant put scroll bars in a single cell. |
|
I am a degen. Do not believe in any of my advice. | |
|
|
|