you want to maximize the number of rows visible
To turn off this feature, go to the Window menu and select Unfreeze Panes. This menu item is only visible after you have frozen the panes.
If you want to maximize the number of rows visible, it is possible to freeze only row 3.
1. First, unfreeze the panes using Window ==> Unfreeze Panes. Place the cell pointer in the last visible row in the window. Hit the Down Arrow twice to force rows 1 and 2 to scroll above the window. Row 3 is now the first visible row, as shown in pic.
2. Place the cell pointer in cell A4 and using the Window ==> Freeze Panes command,as shown in pic.
3.You will now be able to scroll with only row 3 frozen at the top of the window, as shown in pic.
