Maybe you could
Select the range
data|filter|autofilter
and then use the dropdown arrows to show/hide what you want.

Old_skills_lost wrote:

Thank you for that answer.

So is there a way to hide information until it is scrolled up to the reading
area?

Example

I have a worksheet that has 12 weeks on it each week has 16 rows. while
viewing one week can the other 11 weeks be hidden?

"Gord Dibben" wrote:

You do not.

Freeze Panes works only once per window.


Gord Dibben MS Excel MVP

On Tue, 15 Jan 2008 15:06:02 -0800, Old_skills_lost
wrote:

How does one freeze two rows I.E. a1 and a23?



--

Dave Peterson