Column Headers appearing in sort

  • Thread starter Thread starter Ringmaster
  • Start date Start date
R

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.
 
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.
 
Hey Norman....It worked!

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

Thanks,

Ringmaster
 
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.
 
Back
Top