How to change column format? numerical not alphabetical

I

ISco

I apologise if this is a bit of a stupid question, I have had some training
in the past on Excel but not for some years now and so im a bit rusty. At
work ive been working on an Excel file containing statistics, involving a few
formulas but ever since I re-opened the file recently, something has confused
and annoyed me.

What it is, is where usually the rows are all numbered and the columns are
labelled alphabetically (so for instance B3 is the third cell down and the
second cell along from the left), for some reason now both the columns and
the rows are numbered numerically... this wouldn't be so much of a problem if
it weren't for the fact that it confuses me when I try and enter formuas, I
know you can click and drag the mouse over the cells and it automatically
enters the right cell code but it just doesn't seem to make sense, where one
cell far down might be cell 5 (column no.) 145 (row no.) but if I click on
that for a formula, it labels it as (where I type SUM=( to indicate the start
of a calculation/formula) '=SUM(R[-304]C[1]'

This is probably an easy fix but I would love it if I could change/reset it
back so that columns have the usual alphabetical headings... I just don't
understand the above at all, where does the R and the C and this 304 come
from, so it bamboozles me! plus ive no idea why its changed the column
numbering, unless I accidentally hit something by mistake(?), it was right
when I originally started the file im pretty sure... I also wondered if it
was a setting on this one particular computer and managed to try accessing
the file on Excel on another desk computer but that had exactly the same
column heading format, so I guess its not that. It stays the same confusing
format when I try to create a new document too... confusing...

Any help is much appreciated, many thanks in advance.
 
E

Ed Cones

Look in your options for "R1C1 reference style." In ver 2007 it's under
Options, Formulas. Make sure it's not selected.
 
I

ISco

Ah that did it; thanks alot! I've never heard of that before... oh well,
thanks again.

Ed Cones said:
Look in your options for "R1C1 reference style." In ver 2007 it's under
Options, Formulas. Make sure it's not selected.

ISco said:
I apologise if this is a bit of a stupid question, I have had some training
in the past on Excel but not for some years now and so im a bit rusty. At
work ive been working on an Excel file containing statistics, involving a few
formulas but ever since I re-opened the file recently, something has confused
and annoyed me.

What it is, is where usually the rows are all numbered and the columns are
labelled alphabetically (so for instance B3 is the third cell down and the
second cell along from the left), for some reason now both the columns and
the rows are numbered numerically... this wouldn't be so much of a problem if
it weren't for the fact that it confuses me when I try and enter formuas, I
know you can click and drag the mouse over the cells and it automatically
enters the right cell code but it just doesn't seem to make sense, where one
cell far down might be cell 5 (column no.) 145 (row no.) but if I click on
that for a formula, it labels it as (where I type SUM=( to indicate the start
of a calculation/formula) '=SUM(R[-304]C[1]'

This is probably an easy fix but I would love it if I could change/reset it
back so that columns have the usual alphabetical headings... I just don't
understand the above at all, where does the R and the C and this 304 come
from, so it bamboozles me! plus ive no idea why its changed the column
numbering, unless I accidentally hit something by mistake(?), it was right
when I originally started the file im pretty sure... I also wondered if it
was a setting on this one particular computer and managed to try accessing
the file on Excel on another desk computer but that had exactly the same
column heading format, so I guess its not that. It stays the same confusing
format when I try to create a new document too... confusing...

Any help is much appreciated, many thanks in advance.
 
E

Ed Cones

It pops up every now and then. I hadn't heard of it either until a couple of
months ago. I'm happy to get to help once.

ISco said:
Ah that did it; thanks alot! I've never heard of that before... oh well,
thanks again.

Ed Cones said:
Look in your options for "R1C1 reference style." In ver 2007 it's under
Options, Formulas. Make sure it's not selected.

ISco said:
I apologise if this is a bit of a stupid question, I have had some training
in the past on Excel but not for some years now and so im a bit rusty. At
work ive been working on an Excel file containing statistics, involving a few
formulas but ever since I re-opened the file recently, something has confused
and annoyed me.

What it is, is where usually the rows are all numbered and the columns are
labelled alphabetically (so for instance B3 is the third cell down and the
second cell along from the left), for some reason now both the columns and
the rows are numbered numerically... this wouldn't be so much of a problem if
it weren't for the fact that it confuses me when I try and enter formuas, I
know you can click and drag the mouse over the cells and it automatically
enters the right cell code but it just doesn't seem to make sense, where one
cell far down might be cell 5 (column no.) 145 (row no.) but if I click on
that for a formula, it labels it as (where I type SUM=( to indicate the start
of a calculation/formula) '=SUM(R[-304]C[1]'

This is probably an easy fix but I would love it if I could change/reset it
back so that columns have the usual alphabetical headings... I just don't
understand the above at all, where does the R and the C and this 304 come
from, so it bamboozles me! plus ive no idea why its changed the column
numbering, unless I accidentally hit something by mistake(?), it was right
when I originally started the file im pretty sure... I also wondered if it
was a setting on this one particular computer and managed to try accessing
the file on Excel on another desk computer but that had exactly the same
column heading format, so I guess its not that. It stays the same confusing
format when I try to create a new document too... confusing...

Any help is much appreciated, many thanks in advance.
 

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