split and freeze

M

mvi

how to use fix row at top and some fix row at down. just center rows
scrolling!!
is there any way to use both split and freeze panes together at same time.
 
D

Debra Dalgleish

There's no way to freeze rows at the top and bottom of the window.
You could freeze rows at the top, then choose Window>New, to create
another window for the workbook.
Arrange and resize the windows so you can only see a few rows in the
bottom window.

Split and Freeze panes can't be used together.
 
M

mvi

thanks for your help.

Debra Dalgleish said:
There's no way to freeze rows at the top and bottom of the window.
You could freeze rows at the top, then choose Window>New, to create
another window for the workbook.
Arrange and resize the windows so you can only see a few rows in the
bottom window.

Split and Freeze panes can't be used together.
Click to expand...
 
Top