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

How to turn off column letter headings?
 

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" wrote in message
...
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

How to turn off column letter headings?
 

ToolsOptionsView tab, uncheck Row & Column headers.

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

--
Kind regards,

Niek Otten

"VanS" wrote in message
...
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

How to turn off column letter headings?
 

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" wrote in message
...
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

How to turn off column letter headings?
 

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:

ToolsOptionsView tab, uncheck Row & Column headers.

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

--
Kind regards,

Niek Otten

"VanS" wrote in message
...
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

How to turn off column letter headings?
 

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" wrote in message
...
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" wrote in message
...
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

How to turn off column letter headings?
 

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" wrote in message
...
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" wrote in message
...
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