Viewing Data Using Scrollbar

**laffers** · 03-21-2011, 08:08 AM

I have a worksheet with data in the range A8:G98.

Rather than scroll the whole page, I want this data to be available on only 10 rows and to use a scrollbar to view the data.

Can this be done? Does it involve coding?

**Sadath31** · 03-21-2011, 08:47 AM

Want something like this

**Rahul Nagar** · 03-21-2011, 08:48 AM

Hi,

I think you can use Freeze Panes for the same.

**laffers** · 03-21-2011, 09:11 AM

Im in work at the moment so cant download the example file due to restrictions, I'll let you know later on.

Ive tried freeze pane but you can only do it over 1 axis at a time. I need to do it horizontally and vertically

**laffers** · 03-21-2011, 10:07 AM

Actually I can open it as it doesnt contain any Macros.

I can sort of see what you have done. I cant understand how you have managed to squeeze all the data into a 10 x 7 table and also I am having trouble interpreting the OFFSET function, well this part anyway

$J$1+ROW()