letters across the top has changed to number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The letters across the top of my worksheet has changed to numbers, any idea
how I change them back to letters??
 
This happens inadvertently, I think, in the course of clicking through
menus. On the menu if you'll click ~Tools ~Options, choose the General
tab and deselect the "R1C1 Reference style".
 
Tools>Options>General

Uncheck "R1C1 Reference Style"


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
How to change numbered columns to letters? 3
Column headings - urgent help needed please 3
My excel spread sheet has numbers down left side and across top? 6
change excel auto column headers from numeric to alpha 2
Creating sequential numbers plus a letter 4
R1C1 Reference Style Default 5
How do I change Excel column cell identifiers back to letters? 4

Back
Top