Help with Column Lables

I am trying to use Filtering in Excel 2003. I highlight the columns I
wish to include in my filter. I then select advanced filtering and
click ok. When I do I am told that "Microsoft Office Excel can not
determine which row in your list or selection contains column labels,
which are required for this command. " I select OK and it, by default
selects the first row of the selection or list to be used as labels
and not data. This is ok but …

Just how do I create column labels so that I do not constantly get
this prompt. I have looked in help under Creating Labels, Creating
Data Labels and the like but find only references to creating data
labels for charts.

I would love any help someone could give me on this one.

Steve

SMonczka wrote:

I am trying to use Filtering in Excel 2003. I highlight the columns I
wish to include in my filter. I then select advanced filtering and
click ok. When I do I am told that "Microsoft Office Excel can not
determine which row in your list or selection contains column labels,
which are required for this command. " I select OK and it, by default
selects the first row of the selection or list to be used as labels
and not data. This is ok but …

Just how do I create column labels so that I do not constantly get
this prompt. I have looked in help under Creating Labels, Creating
Data Labels and the like but find only references to creating data
labels for charts.

I would love any help someone could give me on this one.

Steve

Simply insert a row at the top of the sheet and give
the col a name. Excel will then use the first cell i
the col as the label.

gls858

This is an old "holdover", from probably XL 5.0, where they recommended
establishing specific names for parts of data lists that would be used in
"Advanced Filters".
They we
"Criteria"
"List"
"Extract"
All with no quotes.

So, select the header row of your data list, click in the name box, and
enter the name
LIST
Then Enter.

You could go the full way, and make an*exact* copy of this header row, place
it three or four rows above the start of you data list, and name it
CRITERIA

Then, go down, beyond the end of your data list, and again make an *exact*
copy of your header row, and name it
EXTRACT

Now, when you use Advanced Filter, you should *not* have to identify your
list, or your criteria range, and when you check "Copy To Another Location",
XL will *automatically* know to place the filtered data under the header row
you named "Extract".

I have to admit, that I really don't know if this works in XL03, but it does
work in my XL02.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"SMonczka" wrote in message
om...
I am trying to use Filtering in Excel 2003. I highlight the columns I
wish to include in my filter. I then select advanced filtering and
click ok. When I do I am told that "Microsoft Office Excel can not
determine which row in your list or selection contains column labels,
which are required for this command. " I select OK and it, by default
selects the first row of the selection or list to be used as labels
and not data. This is ok but .

Just how do I create column labels so that I do not constantly get
this prompt. I have looked in help under Creating Labels, Creating
Data Labels and the like but find only references to creating data
labels for charts.

I would love any help someone could give me on this one.

Steve

Format the heading row differently than the rest of the table, and Excel
should be able to detect the headings.

For example, make the heading row Bold font, and leave the rest of the
table as normal font.

SMonczka wrote:
I am trying to use Filtering in Excel 2003. I highlight the columns I
wish to include in my filter. I then select advanced filtering and
click ok. When I do I am told that "Microsoft Office Excel can not
determine which row in your list or selection contains column labels,
which are required for this command. " I select OK and it, by default
selects the first row of the selection or list to be used as labels
and not data. This is ok but …

Just how do I create column labels so that I do not constantly get
this prompt. I have looked in help under Creating Labels, Creating
Data Labels and the like but find only references to creating data
labels for charts.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thanks all for the data. I'll try it out.

Thanks again
Steve