View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
MartinW
 
Posts: n/a
Default Fixed area above row 1

Hi fwells,

You can't place them above row 1 but you can place them in row 1 or however
many rows you require.

Select an entire row and go to Windowfreeze frames.
This will freeze any frames above the one you selected.

For example if you select row 6 - then rows 1 to 5 will be frozen, select
row 2 and row 1 will be frozen etc.

HTH
Martin