Numbering for column

  • Thread starter Thread starter Phoebe.
  • Start date Start date
P

Phoebe.

Hi, Good Day!

I seldom used microsoft excel but sometimes i do used it for some simple
calculation.

When I just opened an excel spreadsheet, the numbering of column is in
number format(1, 2, 3...) and not in alphabet format(A, B, C...)

May I know how can i reset it back to alphabet?
Thanks in advanced.

rgds,
Phoebe
 
Tools|Options|General|Uncheck R1C1 Reference Style

(this is picked up from the first workbook you open in that session. So make
sure you save your workbook after the change--and make a note of how you fixed
it. It can happen again if the first workbook opened has R1C1 reference style.)
 
Back
Top