horizontal scroll bar references

[Guest]

When I click on my horizontal scroll bar in Excel, it shows "Column: A" etc.
Does anyone know how to change the reference to the column header instead?
I've seen it on a spreadsheet but can't figure out how to do it.

 

[pinmaster]

I think what you want is Data/Groups and Outlines

JG

 

[Guest]

Wow - that actually answered a different question that I was wondering about
yesterday but didn't post - thanks!!

I've gone through that menu and didn't see where I might designate the row
that is the header row to change the scroll bar - can you help direct me?
When I group them, the scroll bar still shows as Column: A etc...

thanks!!