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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top