Thank you appreciated oh wise one.

"Column references within formulas" wrote:

Click on the row below your headers, then go to view on the toolbar click
freeze panes.

"Nevyn" wrote:

Hi folks am after your brains again. I have a sheet with well over 500 rows.
Is there a way to float the column headings so I canh see them at whatever
row I am on.