Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
Currently I have two parts to my sheet. There's a row of field boxes on the top half containing about 100 columns. The bottom is composed of a summative table of the data on top. Since there are so many field boxes, it goes off the page and I have to scroll to look at them. I'm hoping to keep the bottom static as I scroll through the top.
I've tried a container object, but it seems like horizontal scrolling isn't possible. Also, I am hoping not to use a multi box as I'd like to see the data and associated data as I'm scrolling.
Is there such thing as possibly splitting the sheet in half so only the top half moves, or possibly setting the chart on the bottom to static so that it stays on the screen no matter what?
Any help would be appreciated, thanks!
No, that's not possible. Try using multiboxes instead of listboxes to save space. You can also try using buttons to show/hide groups of listboxes on demand.