Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Hi, did you try to delete the row?

does it help?
regards from Brazil
Marcelo

"Kikipelli2000" escreveu:

Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Column headers are part of a List. As far as I know, the best you can
do is hide the row in which the column headers reside.

Kikipelli2000 wrote:
Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Yes - I tried deleting .... my problem is I'm needing something similar to a
drop down list without headers .... boss wants to just select a row from a
list and everything will be filled in magically! .... it's been a little bit
of a challenge! .... thank you so much for your response ... and if you think
of anything else to try - let me know! - Kikipelli

"Marcelo" wrote:

Hi, did you try to delete the row?

does it help?
regards from Brazil
Marcelo

"Kikipelli2000" escreveu:

Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Marcelo, you cannot delete a row which contains the column headers for
a list. Excel just won't let you.

Marcelo wrote:
Hi, did you try to delete the row?

does it help?
regards from Brazil
Marcelo

"Kikipelli2000" escreveu:

Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Try

ToolsOptions...ViewUncheck Row and column headers

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Kikipelli2000" wrote in message
...
Can anyone tell me how to eliminate all column headings in lists - even
the
default ones - from showing? There can't be any headings on this project
I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

You may have to resort to providing your own list functionality using
VBA on ranges.

Kikipelli2000 wrote:
Yes - I tried deleting .... my problem is I'm needing something similar to a
drop down list without headers .... boss wants to just select a row from a
list and everything will be filled in magically! .... it's been a little bit
of a challenge! .... thank you so much for your response ... and if you think
of anything else to try - let me know! - Kikipelli

"Marcelo" wrote:

Hi, did you try to delete the row?

does it help?
regards from Brazil
Marcelo

"Kikipelli2000" escreveu:

Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000

Ops! I didn't have notice, sorry and thanks for the feedback



"Mark Lincoln" escreveu:

Marcelo, you cannot delete a row which contains the column headers for
a list. Excel just won't let you.

Marcelo wrote:
Hi, did you try to delete the row?

does it help?
regards from Brazil
Marcelo

"Kikipelli2000" escreveu:

Can anyone tell me how to eliminate all column headings in lists - even the
default ones - from showing? There can't be any headings on this project I'm
working on. I would really appreciate some input on this seemingly
inconsequential issue! - Kikipelli2000