Link Scroll Bar to multiple cells
on a worksheet I have a block of merged cells that display data collected from another worksheet via vlookup
I am limited with space and noticed that if the collected data was too long not all would be displayed (as it would in access)
is it possible to incorporate a scroll bar function for this merged cell ?
(can it be done in excel2010)
I have a scroll bar control in cell G84 that I need to scroll up
and down the E81 cell which is a merged cell consisting of E81:F83.
Is the scroll bar not working because it is a merged cell?
What can I do to make the scroll bar scroll up and down within that E81 cell that has a lot of typed text?
It is not a protected sheet or locked cell.
Kindly tell me how I can apply the scroll bar in spreadsheet. I am using version 2010.
I am looking to get another scroll bar because I have columns and one is a lot longer than the other one and I always have to scroll up and down so much where if I have 2 it would be a lot quicker.
Im having a boat load of trouble trying to figure out how to do a scroll bar on a graph. im not sure if its the holiday hangover or what, but I cant seem to get my head wrapped up around the offset formula to create a scroll bar graph.
can someone please help me. my graph is stretching really long so it would be great if someone can help me with this, please and thx you. happy new year.
I have attached a sample.
Related Applications & Scripts
Making web design easy. Create colorful scroll bars for IE instantly and with ease using this tool. You select the exact colors you want and where you want them on the scroll bars. Our reference chart makes it easy for you to see what colors will appear where on the scrolls. Additional features include a preview of the generated code.
Its very easy to use this scroll bar in your projects. Just drag & drop scrollBox MC from library to your stage (or MC) and youre done. Support for keyboard (up and down arrows) as well as the mouse scroll wheel.
All the code is placed just in one frame, you dont need to seek if you want to change dynamic parameters:
- Amount of arrow scrolling [pixels]
- Amount of Mouse wheel scrolling [pixels]
- Speed of tweening
- Hide / Show arrows
- Allow / Disable keyboard arrows
- Allow / Disable mouse wheel
This vertical project viewer is controlled by scroll bar. When mouse over each thumbnail, the tooltip can display title and date for it. You can show a lot of projects that contain title, date, description and multiple large pictures with link. You can also edit link, url, target, show time for each large picture. They can be played or paused.