Morning guys,

I got sent a spreadsheet the other day with a really nifty little feature that I've never seen before: -

All looked normal at first - The columns were labelled A,B,C,D............. etc, etc.

Underneath, there was a simple database with the headers: -

Contact Address Email etc, etc

When you scrolled down the spreadsheet, the column headers (A,B,C etc) changed to the column titles used in the spreadsheet (Contact, Address, Email etc)

A bit like using the freeze panes function, but better - made it much easier to navigate the spreadsheet.

Does anyone know how it's done? (Excel 2007)

Thanks in anticipation

Frank