View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Manoj
 
Posts: n/a
Default How to set the row for title to be fixed during scrolling?

Yes

If you want to freeze two rows and the leftmost 2 columns, go to cell c3 and
hit windows--freeze panes in the menu

when you want to freeze any numberr of rows or columns go to a cell that is
one row below the rows you want to freeze and one column to the right and
then click windows-- freeze panes.

e.g., 4 top rows and 3 left columns then the cell is d5

Trust this meets your requirements

"Eric" wrote:

Thank everyone for suggestions
Will it be possible to freeze panes for row and column at the same time?
rather than freeze only for row or column
Thank you
Eric