Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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.