ps. Debra Dalgleish has lots of info about autofiltering:
http://contextures.com/xlautofilter01.html
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