Document number: 15169

 

Normally, the columns on Excel spreadsheets are labeled with letters. The rows are labeled with numbers. If your column labels are showing numbers instead of letters on your Excel spreadsheets (click here to see an example), follow the steps below to restore the letter column labels:

1. Save and close any open spreadsheets.

2. Open a blank spreadsheet.

3. Click on the Tools menu, then on Options...

4. Click on the General tab.

5. There should be a check in the box next to R1 C1 reference style in the Settings section at the top of tab. Clear the checkbox.

6. Click OK.

The column labels should now be alphabetical.

 

 

 

 

 

 

Created by the PeopleSoft Knowledge Management Team.
Copyright © 2003 All rights reserved.
Created: kcw 04/25/2003
Reviewed: 04/28/2003