Is it possible to rename Excel's "A"- "B"- "C"- etc.- headings?


#1

Is it possible to rename Excel's "A", "B", "C", etc., headings? (I'm not talking about the first Excel row, but the actual topmost Excel-supplied headings.)

If so, could someone post sample code for doing this in Aspose.Cells?

What I'd like to do is write a sentence that spans, for example ABCDEFG and yet does not disturb the fact that there are 7+ actual Excel columns into which the user can enter data.


#2

I don't think it can be changed because I don't find that MS Excel allows to do it.

If you want to write a sentence which can span several columns, you don't need to change the column headings. I think merging cells over several columns is enough.


#3

Thanks for the response, Laurence. I had wanted to use the space consumed by ABC etc., not the actual Excel cells. It sounds like that’s not a workable solution.