We help IT Professionals succeed at work.

No Column Headings in MS-Excel 2007 as in A, B, C, ....AA,... AZ,...BA,...BZ...etc....etc.

Medium Priority
275 Views
Last Modified: 2012-05-12
EE Experts:

I have an MS-Excel 2007 workbook that I use to keep track of the time I spend on various projects, I use the same simple format on many Excel workbooks that I use to keep track of stuff. One workbook with 12 sheet tabs for the months. I know that it is possible to do very advanced, exotic, ..., brilliant work in Excel. I try to do that kind of work in other places. I just need the simple stuff in MS-Excel 2007. The column headers on some of the sheets are not showing up, but they are there on other sheets in the same workbook. I have set the only configuration parameter that I can find to fix this, and it is not having any effect. Please see screenshot of the parameter I have set. Oh! BTW, the row headers are OK so far in all workbook sheets.

This is making me bullistic crazy angry because I have other deadlines that are very important to me, and now I have to spend my time wrestling with this. This is not the first time I have had this problem. I have just been puttin it off till now. I would be most appreciative of whatever help you can give me.

Thank you very much in advance,
Ted Palmer
NoColumnHeadingsWhy.bmp
Comment
Watch Question

The columns are might hidden for a purpose.

Try to select all the columns and then right click -> Unhide columns

Ed
Retired
CERTIFIED EXPERT
Top Expert 2012
Commented:
Does changing the Headings checkbox in the Show/Hide group on the View tab make any difference?
Ted PalmerInformation Technology Consultant

Author

Commented:
Ed,

Thank you, but the columns are not hidden, just the letters in the column headers at the top. The reason that is a problem for me is that without them I can not resize the width of the column.

Ted Palmer
CERTIFIED EXPERT
Commented:
check excel options, advanced, options for this sheet, show/row column headings

if thats not the problem can you post a sanitised copy on here?

reg
How about select all the columns and then just adjust the width of one of the columns.

Ed
Ted PalmerInformation Technology Consultant

Author

Commented:
GrhamSkan:

That was it. How can I have been so blind? Thank you very much. I found the attached and believed that was it. My confidence in that choice sank when I noticed the "Print" label near it.

Thanks you got it.
Ted
Excel2007PageLayoutGridlines-Hea.bmp
Ted PalmerInformation Technology Consultant

Author

Commented:
Thank you Graham and regmigrant.
Ted PalmerInformation Technology Consultant

Author

Commented:
ALL,

Question closed, Points awarded so I can not change anything, but the problem was the splitter bar. I first thoought Question was answered because I tested it on the wrong workbook. I saw the behavior I wanted to see; so I thought that fixed it. I looked back in my knowledge base. I asked this same question 5 months ago. Whoever designed the behavior of that splitter bar, merits my undying contempt. It is a good thing I am not a violent person. That could really make me want to hurt somebody.

Ted Palmer
GrahamSkanRetired
CERTIFIED EXPERT
Top Expert 2012

Commented:
Thanks for the feedback of what the problem actually was. If it happens to anyone else in the future, or to one of us in a forgetful moment, we should be able to find the answer here.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.