No Column Headings in MS-Excel 2007 as in A, B, C, ....AA,... AZ,...BA,...BZ...etc....etc.
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
How about select all the columns and then just adjust the width of one of the columns.
Ed
Ed
ASKER
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
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
ASKER
Thank you Graham and regmigrant.
ASKER
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
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
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.
Try to select all the columns and then right click -> Unhide columns
Ed