View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Leo Ibrahim Shb Leo Ibrahim Shb is offline
external usenet poster
 
Posts: 1
Default 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.