freezing cell on 3 planes

[burnsie]

Hi.

I have a table that is frozen in b5 meaning that the first column ("A") and rows 1-4 are frozen.

The table is large with ever expanding rows.

What I want to do is, a good few rows down (say row 300), freeze the row at the bottom of my view and use that row as a mean average row. Therefore allowing me to enter much more data above, but constantly be able to see the averages of the data I am adding.

Does this make sense, and can this be done?

Thanks once again.

[DonkeyOte]

Not something I know much about really but you could perhaps add a 2nd window ?

The Freeze will apply only to the first window and such that window should be placed at top, 2nd window below.
The 2nd window could be scrolled to the row containing the averages and resized appropriately (ie to show only one or two rows) meaning the remainder could be filled by window 1 which you will use for data entry complete with freeze.

[Andy Pope]

Could you not place a reference to that row in the top frozen pane?

[burnsie]

wood for the trees

I have now put my averages row at the TOP of my table.