View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default How do I freeze panes horizontally and vertically at same time

when you freeze panes the rows above, and the columns left of the selected
cell are frozen. So to freeze columns A-B and rows 1-3 select C4 and then
select window-freeze panes.

"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.