View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
VanS
 
Posts: n/a
Default 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