Topics Map > OS and Desktop Applications > Applications > Productivity

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 disabling the "R1C1 Reference Style" feature in the following versions of Microsoft Office:

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

  2. Click on General.

  3. Uncheck R1C1 Reference Style.

  4. Click OK at the bottom.

Office 2010/2013 (Win)

  1. Click on the File tab at the top of the screen and select Options.

  2. Click Formulas.

  3. Uncheck R1C1 Reference Style.

  4. Click OK at the bottom of the window.

Office 2007 (Win)

  1. Click on the Office button in the top left 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 (Win)

  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:Leah S.Group:DoIT Help Desk
Created:2000-11-21 19:00 CDTUpdated:2016-03-22 16:18 CDT
Sites:DoIT Help Desk, Fox Valley Technical College DEMO, New Mexico State University, OHIO University , Pacific Lutheran University, Parkland College, Peking University (北大) Test KB, Rice University, Southern Illinois University Edwardsville, University of Illinois at Chicago ACCC DEMO, University of Illinois Liberal Arts and Sciences, University of Illinois Unified, University of Mississippi Medical Center, UW Oshkosh , UW Platteville, UW-La Crosse, Wheaton College DEMO, York College of Pennsylvania Demo
Feedback:  2057   101