show column headings

[John Grandy]

I believe you assign a heading to a column by selecting the column and
entering text ...

.... but my worksheet is in a strange mode where the heading doesn't show up
in the column header cell. Instead, the default "A","B","C" headings
appear.

 

[JLGWhiz]

You cannot make manual entries into the default header row where the A, B,
C... automatically appear upon opening a file. You have to use one of the
rows which start with row 1, but you can use any row for a header row if you
do not like row 1. Then just list your other data beneath the headers.
Now, Excel also provides for headers and footers on the printed pages.
Those are handled thro8ugh the Page Setup facility.

 

[John Grandy]

But I have a Workbook where the the first 6 column headers have been
replaced with custom text.

I didn't create this Workbook, but someone figured out how to do it.

 

[JLGWhiz]

It is beyond my knowledge.

But I have a Workbook where the the first 6 column headers have been
replaced with custom text.

I didn't create this Workbook, but someone figured out how to do it.

 

[FSt1]

hi
excel gives you the option to show or hide the default headers(and row
numbers).
to hide the default header ie A,B,C, etc (and row numbers)...
on the menu bar>tools>options>view tab>uncheck "row & column headers".
you can then use row 1 for custom headers. the default headers are still
there just hidden. excel needs these default headers and row numbers. that is
the way excel keeps track of everything and knows where everything is at.
excel reserved.

Regards
FSt1

 

[John Grandy]

Thanks.

But my Workbook still has the row headers column and the column headers
row -- I know because in Excel 2007 I de-select View > Headers and the top
row and leftmost column dissapear.

But for my column headers, the "A" , "B" , "C" have been replaced with
custom text.

 

[JLGWhiz]

Is it just in one workbook, or in all workbooks?

 

[JLGWhiz]

Is there a row number in the extreme left cell of that header row?