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" wrote in message
...
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" <john.arthur.grandy-at-gmail.com wrote in message
...
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.