Why does my Excel shows the rows and the columns as numbers?

  • Thread starter Coulum/Row Reference
  • Start date
C

Coulum/Row Reference

The row references are number and, usually, the column references are
letters; however, somehow my Excel file was changed and the rows and colums
are numbers. How did this happen and/or how do I change it back?
 
P

Peo Sjoblom

Tools>options>general remove checkmark from R1C1 reference style

--


Regards,


Peo Sjoblom
 
T

Tom Hutchins

Tools >> Options >> on the General tab, uncheck the R1C1 reference style box
Hope this helps,

Hutch
 
H

Harald Staff

Hi Peo

Most replies in newsgroups seem to -& most often correctly- assume that the
OP is not using Excel 2007? Is there any explanation to this?

Best wishes Harald
 
P

Peo Sjoblom

Hi Harald,

I just assumed

Plus of course unless this is the OP's first Excel experience most users
mention that they
use 2007 if that's the case.

--


Regards,


Peo Sjoblom
 

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

Columns now numbers rather than letters how do i get letters back 2
column headers changed from letters to numbers, how do I change ba 1
why is it printing the numbers and letters from the rows and colu. 3
Columns are numbers instead of letters 4
Make Excel see columns as rows and rows as columns 3
reference format and column name 1
Excel sheet with numbers as column & row headers - How? 3
Why did my Excel column headers change from letters to numbers? 4

Top