Changing the column titles to the spreadsheet titles when scrolling down

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

The data has been formatted into a table. Very handy feature.

Originally Posted by Marcol

Hi Frank the Haddock



At the risk of sounding dumb, but if....

Why don't you check-out the spreadsheet, it's surely the solution to the problem you pose. No?

Hi Marcol,

Apologies, I am a bit dumb about Excel, that's why I joined this forum - so I could learn and hopefully help other users some day.

I did try and figure it out in the spreadsheet itself, I right clicked here there and everywhere looking for clues. Right clicked the column headers looking for Sub menu's etc.

Selected the entire table then clicked all the Review / View menu options.

Problem is that I simply don't know where to look :-)

Thanks for the response anyway

Frank

Can you post a sample of the workbook, disguising any potentially sensitive data?