Freezing

O

Old_skills_lost

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?
 
D

Dave Peterson

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

Gord Dibben

Not too easily but here are a couple of ways to do it.

Resize rows and columns so's only one week shows on the screen

Create a named range for each week............week1, week2, week3 etc.

Select the name from the Namebox to jump to that range.

OR you can create 12 Custom Views for each week with other rows and columns
hidden.

Then drag the Custom Views button to your toolbar and click on it to choose your
view.......week1, week2, week3 etc.

Don't forget to add a name for the full view first.


Gord
 
Top