Freeze Panes Question

[JeffK627]

I'm trying to use Freeze Panes in Excel 2007 so that ONLY the cells below and to the right of F10 will scroll. I've tried selecting cell G11 and then freezing panes, but the result is that rows 1 to 10 in columns G and beyond still scroll horizontally. Is there a way to freeze panes so that this doesn't happen?

 

[Smitty]

3. Columns G, H, etc. need to scroll horizontally, but only from row 11 on. So I need a sort of upside-down "L" shaped area that doesn't scroll.

Not gonna' happen.

About all I can think of is to use a non-printing text box over rows 1-10. Columns would still scroll, but they'll be hidden from view.

 

[Michael M]

Umm, you could also write a VBA to change all fonts to white on opening in that area, and then back to normal on closing. Or assign it to a button.

 

[Smitty]

Umm, you could also write a VBA to change all fonts to white on opening in that area, and then back to normal on closing.

That could be pretty slick.

 

[Michael M]

from F1 to Z10

Sub Macro1()
    If Range("F1:Z10").Font.ColorIndex = 1 Then 'if it's white
    Range("F1:Z10").Font.ColorIndex = 2 'make it black
    Else
    Range("F1:Z10").Font.ColorIndex = 1 'make it white
    End If
End Sub

you could also include the interior colur if it was consistent