Column Headers appearing in sort

[Ringmaster]

When I do a search, the "Column Headers" appear in the search results,
but not as column headers, they get mixed in, and included in the
"alpha" sort. How do I lock "column headers", so that they remain as
column headers in the search results.

 

[Norman Harker]

Hi Ringmaster!

If you select the data inclusive of headers, make sure that you select
the "My data has..... header row" option

If you select the data exclusive of headers, make sure you select the
"My data has..... no header row" option


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Ringmaster]

Hey Norman....It worked!

You can't imagine how many combinations I tried, before I went to the
"Forum"

Thanks,

Ringmaster

 

[Norman Harker]

Hi Ringmaster!

Good to hear that you are on the way again.

See you around the newsgroups.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.