How do I freeze panes horizontally and vertically at same time
"Pete_UK" wrote:
If you place the cursor in cell B2 then Window | Freeze Panes you will
find the top row and column A will be "frozen" as you scroll around the
sheet. Try it with C2 selected - this will fix A and B in place as well
as the top row, i.e. all rows above and all columns to the left of the
cell you select when doing Window | Freeze Panes will be frozen on
screen.
Hope this helps.
Pete
BW wrote:
I would like to be able to freeze panes, such as headers, horizontally, as
well as freezing panes in a column, such as listing of names.
This is not work on Excel 2007.
Please help me.
|