University of Wisconsin Help Desk Knowledgebase

• Contact Us
• DoIT
• UW
• MyUW
• PEOPLE

Microsoft Excel - Column Labels Are Numbers Instead Of Letters

Microsoft Excel can be configured to display column labels as numbers instead of letters. This feature is called "R1C1 Reference Style", and though it can be useful, it can also be confusing if inadvertently enabled.

This document contains instructions for Excel included in the following versions of Office:

• Office 2008 (Mac)
• Office 2007 (Win)
• Office 2003 and Earlier

Office 2008

1. Click on the Excel menu at the top and select Preferences

   

2. Click on General.

   

3. Uncheck R1C1 Reference Style.

4. Click OK at the bottom.

   

Office 2007

1. Click on the Office button in the top right hand corner.

2. Click on Excel Options.

   

3. Select the Formulas tab on the left.

4. Uncheck R1C1 Reference Style.

5. Click OK at the bottom.

   

Office 2003 and Earlier

1. Click on the Tools menu.

2. Choose Options.

3. Click on the General tab.

4. Uncheck R1C1 Reference Style.





---

Keywords:	excel xp 2001 2002 2003 2007 2008 column label number letter r1c1 format display header reference	Doc ID:	781
Owner:	John S.	Group:	Help Desk
Created:	2000-11-22	Updated:	2009-04-10




Did this document help you to answer your question?

Yes.   No.   I have feedback.