Video |
Similar Helpful Excel Resources
This free excel video tutorial shows you how to change the columns in excel 2007 from letters to numbers. This is a change in the reference style within excel. This is a neat trick which you can do to change how excel looks or simply just to annoy someone who might not know how to change excel back. And, you will also learn how to change the columns back into letters from numbers.
This reference style, with numbers as columns instead of letters, is known as the R1C1 style.
Topics Covered
 Change Letters into Numbers for Columns in Excel 2007 Convert Column Numbers back into Letters Trick in excel to annoy someone R1C1 Reference Style in Excel
Difficulty: Easy
Video: Yes
|
Recently when I open Excel, both the rows and columns are numbers. They are
referenced R1C1, instead of A1 for row one column one. When I use Excel on
another computer and then open that saved file on mine, then it is fine. The
problem occurs when I attempt to open a new spreadsheet from my cpu.
Any suggestions? I have obviously changed a setting somehow.
Thank you.
Hi everyone,
I have a very urgent matter I need to solve.
I have an excel sheet that has columns with numbers that I want to change into letters as a code.
For example:
The key is 1=A 2=B 3=C 4=D 5=E 6=F 7=G 8=H 9=I 0=J and for a repeating number (only the first repeat) =W.
So for example if my number is 1539 = AEBI
If the numbr is 1000 = AJWJ
Can someone help me come up with some sort of formula for this?
I'm importing a 3rd party CSV file into Excel and then comparing some of
the contents to a printed spec. Each numbered field in the spec
corresponds to a column in the work sheet. I'd like to change the column
headers from letters to numbers. Is that possible?
I don't see anywhere to change this. I copied a client's spreadsheet and now
all of my Excel sheets have numbers for the columns and the rows. It is
making it hard to do formulas. Please help!
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.
My excel 2007 just started labeling the columns as numbers now (1,2,3, etc) instead of letters (A,B,C, etc). How do I fix this?
Thanks,
Nate
Hi there,
I found this link to an answer but it was related to Excel 2003 and the answer works. But I am using the newer Excel so the same answer can't help me.
http://www.excelforum.com/excel-gene...o-numbers.html
How do I change the columns back to letters.. it's extremely annoying and I have no idea how this happened in the first place!
Thanks
A coworker asked me to help him with his excel file. He opened a file that had numbers instead of letters in the column labels, now he is seeing it in other files he linked that file to. How do you change it back? The name box even says R34C7 or R23C90 for Row and Column.
My excel columns somehow reverted to numbers instead of letters. How can I
change the format back to letters?
The columns are labeled in numbers. How do I change this to letters.
