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.

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.

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.

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.

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.

Hi Aaron

Place your cursor in cell B2, then WindowsFreeze panes
This will lock row 1 and column A so they will always be visible as you
scroll across the screen or down the screen.

You can lock as many rows or columns as you wish, in this way, according
to where you pace your cursor when you invoke the Freeze Panes.
To cancel, just choose WindowsUnfreeze Panes

--
Regards

Roger Govier


"Aaron" wrote in message
...
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.

Finally, I found the answer. None of the ones supplied pertained to the
question. Since I had the same dilemma. Anyways, You would go to Data -
Filter - Advanced Filter. Then go to Data - Sort - Sort by would show the
names if the My Data Range has Header Row checked.

I hope this helps you, it helped me.


"kc977" wrote:

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.

Alternate............without using Advanced Filter.

DataSort. Make sure you have "My data range has headers" checkmarked.

These will show instead of the columns A, B etc.


Gord Dibben MS Excel MVP


On Tue, 15 May 2007 09:08:01 -0700, Fey wrote:

Finally, I found the answer. None of the ones supplied pertained to the
question. Since I had the same dilemma. Anyways, You would go to Data -
Filter - Advanced Filter. Then go to Data - Sort - Sort by would show the
names if the My Data Range has Header Row checked.

I hope this helps you, it helped me.


"kc977" wrote:

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.