Excel noobie question: how to change columns from numbers to letters.

P

Pitch

Not sure how it happened, but all my spreadsheets in Excel v11.3.5 how
have numbers for column headers as well as row headers. I've been
poking around the prefs and Help menu all morning, looking for a way
to turn the columns back to A,B,C (instead of 1,2,3). Does anyone know
how to do this?

In other words, both my rows and columns are labeled 1,2,3,4,5, etc. I
want my rows to stay that way, and the columns to be A,B,C,D...
 
P

Pitch

Never mind. Found it:

Excel Preferences > General

Uncheck R1C1 reference style

Ah, the ol' R1C1 reference.
 
Top