How do I label a column?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 tools>options>view tab and then use the
1st row for your labels and then freeze the panes to maintain visibility.
 
Thanks!

Will that allow me to use my first row names as my column labels for sorting
purposes?
 
Just use the first row as the header row in your sort.
data>sort>options>use header row??
 
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?
 
Hi Aaron

Place your cursor in cell B2, then Windows>Freeze 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 Windows>Unfreeze Panes
 
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.
 
Alternate............without using Advanced Filter.

Data>Sort. 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
 
Back
Top