Scrollable area

Amnesia_180

New Member
Joined
Jan 25, 2005
Messages
14
Hi there,

I have been searching through some topics on this board and have not found an answer to my question yet.

Here is an example of what I am trying to do.

Cells A1 - A6 are occupied... so are B1-B6, C1-C6 etc

Now, A7-A14, B7-B14 etc Have lots of information, so I want these 7 cells to be scrollable, for say 100 cells. So instead of having A7-A14 you have A7-A107 but only see A7-A14 unless you scroll down. Then att the bottom of all that you have the total, in what would be A108 but it shows just below A14.

I believe this is similar to Freeze window formula?

Do you know what I mean?
I hope you can help

Thanks
Amnesia
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Amnesia_180

New Member
Joined
Jan 25, 2005
Messages
14
Hi,
In order for this to work I would need to split the area/window in 2 places. Is this possible?
 

Watch MrExcel Video

Forum statistics

Threads
1,118,826
Messages
5,574,530
Members
412,601
Latest member
TheBeaniacExpress
Top