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
|