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

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,216,376
Messages
6,130,249
Members
449,568
Latest member
mwl_y

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
Back
Top