Excel Forum

Change Columns from Letters to Numbers in Excel 2007

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

Got a Question? Ask it Here in the Forum.