Column Headings in Lists

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

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

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

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

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
>
>

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

Try

Tools>Options...>View>Uncheck Row and column headers

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


"Kikipelli2000" <[email protected]> wrote in message
news:[email protected]...
> 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