https://www.liquidpoker.net/


LP international Poland    Contact            Users: 295 Active, 2 Logged in - Time: 21:26

Microsoft Excel Help

New to LiquidPoker? Register here for free!
Forum Index > Poker Blogs
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

0 votes
Facebook Twitter
I am a degen. Do not believe in any of my advice. 

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 

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. 

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

Chi Chi get the yeyo! 

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.


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. 

 



Poker Streams

















Copyright © 2024. LiquidPoker.net All Rights Reserved
Contact Advertise Sitemap