columns appear as numbers not letters

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

Guest

i have just opened a spreadsheet in excel, and rather than the columns
showing as A B C they are showing the same as rows, in numbers 1 2 3. This is
not normal and i can't write formulas.
 
go to Tools > Options > General tab > under Settings uncheck R1C1
reference style.
 
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
Having Blank Cells, etc. ? 1
Excel sheet with numbers as column & row headers - How? 3
column headers appear as numbers not letters 1
Excel Column labels show as numbers 2
Creating sequential numbers plus a letter 4
Column headers numbers instead of letters 2
Columns now numbers rather than letters how do i get letters back 2

Back
Top