Column tags no longer letters?!

G

GD

Ok, strange one. I produced a document recently which I periodically check on
for accuracy etc. I've opened it up today and for some odd reason the column
labels are no longer 'A' B' 'C' etc but are numbered in the same manner as
the row labels. Also, cell references are changed - for example what would be
cell A1 is now R1C1!?

I'm not sure if this has been changed by someone else or not, but it's
making my monthly upkeep almost impossible! Any thoughts?
 
M

Mike H

Hi,

Tools|Options - general tab and un-check R1C1

This happens if the first workbook you open in a session uses r1C1

Mike
 
G

GD

Many thanks Mike, that sorted it.

Mike H said:
Hi,

Tools|Options - general tab and un-check R1C1

This happens if the first workbook you open in a session uses r1C1

Mike
Click to expand...
 

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

Excel 2007 changed the column Letters into numbers 1
Excel 2007 change column labels from numbers to letters 8
Address label template no longer shows cells 3
Column heads are numbers 4
Column Names 4
How do I change column labels from numbers to letters in Excel? 2
How to change column format? numerical not alphabetical 3
Excel 2007: Column Reference changed from Alpha to Numeric, ? 2

Top