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
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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?
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,167,835
Messages
5,855,910
Members
431,772
Latest member
dannyboi1

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top