I've always used this method, and it works fine for most things. However,
sometimes, I wish the headers would follow the data. For example, if I have
a very wide worksheet, when I scroll too far to the right, I no longer have
my reference headers, only the row numbers. Is anyone aware of a function,
or plugin that would allow us to label the fixed row/column headers so that
custom labels are always visible regardless of how far one scrolls?

"Don Guillett" wrote:

Just use the first row as the header row in your sort.
datasortoptionsuse header row??

--
Don Guillett
SalesAid Software

"kc977" wrote in message
...
Thanks!

Will that allow me to use my first row names as my column labels for
sorting
purposes?

"Don Guillett" wrote:

You can hide the rows/columns in the toolsoptionsview tab and then use
the
1st row for your labels and then freeze the panes to maintain visibility.

--
Don Guillett
SalesAid Software

"kc977" wrote in message
...
I am creating a sheet to keep track of my organization's volunteers and
their
specific skills, and will often have to sort the chart, in case we need
people for certain duties. I want to re-label my columns, so that when
I
go
to sort the data, it allows me to sort by "Baking", or "Cleanup"
instead
of
"Column A", "Column B" and so on. There must be some way to do this, as
I've
seen columns given actual names on other worksheets, but don't know how
to
do
it myself.