Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I take information in 1 column to make column headings? | Excel Discussion (Misc queries) | |||
IF/AND/OR/DATEIF Issue...sorry...long post... | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
What will cause column headings to change from letter to number? | Excel Discussion (Misc queries) | |||
move column headings from row to column | Excel Worksheet Functions |