Hi Dave, You say I have to press "show all data" before freezing.
Well I have some shared(multiple users) + filtered(multiple columns) and
freezed(multiple rows) sheets and the keep freezing completely (not just the
top 5 rows until the filters but evrything like a scroll lock) and I'm
totally out of options on how to resolve this problem.
Try searching on "freezing panes" is not really helpful :) because you end
up in these topics, so I keep on searching hoping you know what I'm talking
about.

Kim Hovestad

"Dave Peterson" wrote:

ps. If you have your data filtered, show all the data before freezing the
panes.

Dave Peterson wrote:

Select A1 (so you can see that cell)
Select A5
Window|Freeze panes
(xl2003 menu system)

Everything above and to the left of that selected cell will be frozen.

If you had selected B5, then column A would have been frozen so you could scroll
right and keep column A in view.

Pat wrote:

Hi! I'd like to know how I for instance could block say, rows 1 to 4 from
scrolling on my sheet so that I can use these rows for titles and so on...

Many thanks!

--

Dave Peterson

--

Dave Peterson