thanks so much for this solution... it was really, really helpful
may you be blessed this day

" wrote:

Just above the up (top) arrow in the right-hand vertical scroll-bar
theere is a very small button, the width of the scroll-bar and of
height about a third of its width.

With the column headers at the top of the visible screen, drag this
small button down one row.

The screen will split into two with a horizontal divide. When you
scroll the bottom spreadsheet the top (column headers) stay still.

Similarly for a vertical split by dragging the small button the the
right of the right hand arrow of the horizontal scroll bar.

OR

Select the row below the column headers by clicking in the row
indicator column. Then select Window Freeze from the main window.

Alan Lloyd