How to turn off column letter headings?

How do I turn off column letter headings in Excel so that it is just blank? I
couldn't seem to find anything in MS documentation?
Thanks, blessings
Van

Van, tools, options, uncheck row and column headers

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"VanS" <VanS@discussions.microsoft.com> wrote in message
news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> How do I turn off column letter headings in Excel so that it is just
blank? I
> couldn't seem to find anything in MS documentation?
> Thanks, blessings
> Van

Tools>Options>View tab, uncheck Row & Column headers.

As it says, you lose your row headers as well.

--
Kind regards,

Niek Otten

"VanS" <VanS@discussions.microsoft.com> wrote in message
news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> How do I turn off column letter headings in Excel so that it is just
> blank? I
> couldn't seem to find anything in MS documentation?
> Thanks, blessings
> Van

Paul,
Thanks for your reply. Followup questions:
I want to turn off just the column headers, not the row headers.
Can you tell me how to do just that, and secondly, not just for each
worksheet invidividually, but for all worksheets in the workbook? How can I
do that?
And also, do you know the syntax to do that programmatically in VBA?
Thanks, God bless
Van


"Paul B" wrote:

> Van, tools, options, uncheck row and column headers
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "VanS" <VanS@discussions.microsoft.com> wrote in message
> news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> > How do I turn off column letter headings in Excel so that it is just
> blank? I
> > couldn't seem to find anything in MS documentation?
> > Thanks, blessings
> > Van
>
>
>

I appreciate your response Niek,
Thanks for your reply. Followup questions:
I want to turn off just the column headers, not the row headers.
Can you tell me how to do just that, and secondly, not just for each
worksheet invidividually, but for all worksheets in the workbook? How can I
do that?
And also, do you know the syntax to do that programmatically in VBA?
Thanks, God bless
Van



"Niek Otten" wrote:

> Tools>Options>View tab, uncheck Row & Column headers.
>
> As it says, you lose your row headers as well.
>
> --
> Kind regards,
>
> Niek Otten
>
> "VanS" <VanS@discussions.microsoft.com> wrote in message
> news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> > How do I turn off column letter headings in Excel so that it is just
> > blank? I
> > couldn't seem to find anything in MS documentation?
> > Thanks, blessings
> > Van
>
>
>

VanS, it is both on or off you can not do on or the other, you could cut
them off and number the rows yourself, you could put in a number for each
row or put in =ROW() and copy down this way they will change if you insert
or delete a row, here is one way to cut them all off at once in the workbook

Sub Cutoff_display_headings()
Dim sh As Worksheet
For Each sh In Worksheets
sh.Activate
ActiveWindow.DisplayHeadings = False
Next
End Sub


--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"VanS" <VanS@discussions.microsoft.com> wrote in message
news:0E9FDEA8-766B-43BE-82CE-957E836EC908@microsoft.com...
> Paul,
> Thanks for your reply. Followup questions:
> I want to turn off just the column headers, not the row headers.
> Can you tell me how to do just that, and secondly, not just for each
> worksheet invidividually, but for all worksheets in the workbook? How can
I
> do that?
> And also, do you know the syntax to do that programmatically in VBA?
> Thanks, God bless
> Van
>
>
> "Paul B" wrote:
>
> > Van, tools, options, uncheck row and column headers
> >
> > --
> > Paul B
> > Always backup your data before trying something new
> > Please post any response to the newsgroups so others can benefit from it
> > Feedback on answers is always appreciated!
> > Using Excel 2002 & 2003
> >
> > "VanS" <VanS@discussions.microsoft.com> wrote in message
> > news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> > > How do I turn off column letter headings in Excel so that it is just
> > blank? I
> > > couldn't seem to find anything in MS documentation?
> > > Thanks, blessings
> > > Van
> >
> >
> >

Thanks for your help, Paul.
God bless,
Van

"Paul B" wrote:

> VanS, it is both on or off you can not do on or the other, you could cut
> them off and number the rows yourself, you could put in a number for each
> row or put in =ROW() and copy down this way they will change if you insert
> or delete a row, here is one way to cut them all off at once in the workbook
>
> Sub Cutoff_display_headings()
> Dim sh As Worksheet
> For Each sh In Worksheets
> sh.Activate
> ActiveWindow.DisplayHeadings = False
> Next
> End Sub
>
>
> --
> Paul B
> Always backup your data before trying something new
> Please post any response to the newsgroups so others can benefit from it
> Feedback on answers is always appreciated!
> Using Excel 2002 & 2003
>
> "VanS" <VanS@discussions.microsoft.com> wrote in message
> news:0E9FDEA8-766B-43BE-82CE-957E836EC908@microsoft.com...
> > Paul,
> > Thanks for your reply. Followup questions:
> > I want to turn off just the column headers, not the row headers.
> > Can you tell me how to do just that, and secondly, not just for each
> > worksheet invidividually, but for all worksheets in the workbook? How can
> I
> > do that?
> > And also, do you know the syntax to do that programmatically in VBA?
> > Thanks, God bless
> > Van
> >
> >
> > "Paul B" wrote:
> >
> > > Van, tools, options, uncheck row and column headers
> > >
> > > --
> > > Paul B
> > > Always backup your data before trying something new
> > > Please post any response to the newsgroups so others can benefit from it
> > > Feedback on answers is always appreciated!
> > > Using Excel 2002 & 2003
> > >
> > > "VanS" <VanS@discussions.microsoft.com> wrote in message
> > > news:CFA9F6D6-F7C4-4465-BAB3-46A5C487FAC4@microsoft.com...
> > > > How do I turn off column letter headings in Excel so that it is just
> > > blank? I
> > > > couldn't seem to find anything in MS documentation?
> > > > Thanks, blessings
> > > > Van
> > >
> > >
> > >
>
>
>