Office Settings & Configuration

How to Change Excel Numeric Headings Back to Alphabetic in WPS Office

John WilsonJohn Wilson Nov 13, 2026 868 views

Question details

The user wants to restore alphabetic column letters in an Excel worksheet because the sheet is showing numeric column headings, which indicates that Excel's R1C1 reference style is enabled.

How to Change Excel Numeric Headings Back to Alphabetic
Product
Microsoft Excel
Device & OS
not provided
Scenario
The user opened an Excel workbook and saw column headings displayed as numbers instead of letters, making formula references harder to follow.
Observed behavior
Worksheet column headings appear as numbers because the R1C1 reference style is enabled in Excel.
Before you start

Open the workbook where column headings currently show numbers. In WPS Office Spreadsheets, click Menu > Options; in Excel for Windows, click File > Options; on Excel for Mac, click Excel > Preferences.

Solution 1Recommended

Turn Off R1C1 Reference Style in WPS Office Spreadsheets

Use this method when you are working in WPS Office Spreadsheets or want to open the Excel file in WPS and restore alphabetic column headings.

R1C1 reference style is an application-level display setting. It does not change your data, but it changes column labels from letters to numbers.

1
Open the workbook in WPS Spreadsheets

Launch WPS Office Spreadsheets and open the worksheet where the headings appear as numbers.

2
Open Options

Click the Menu button in the top-left corner and choose Options.

3
Locate R1C1 reference style

In the Options dialog, select General and find the R1C1 reference style check box under Working with formulas.

4
Disable the setting

Clear the R1C1 reference style check box and click OK.

5
Confirm alphabetic headings

Return to the worksheet and verify that column headings now show A, B, C instead of 1, 2, 3.

Turn Off R1C1 Reference Style in WPS Office Spreadsheets
Headings restored: The change applies immediately and does not alter cell values or formulas.
WPS Office Spreadsheets

Restore Alphabetic Column Headings with WPS Office Spreadsheets

WPS Office Spreadsheets can open your Excel workbook and let you turn off R1C1 reference style, so column headings switch back to letters. The original file remains in .xlsx format, and the familiar Options dialog makes the fix easy.

  1. 1. Open the workbook in WPS Office Spreadsheets: Launch WPS Office Spreadsheets and open the Excel file where column headings appear as numbers.
  2. 2. Click Menu and choose Options: Click the Menu button in the top-left corner and select Options.
  3. 3. Go to General: In the Options dialog, select General and locate the R1C1 reference style check box under Working with formulas.
  4. 4. Clear R1C1 reference style: Clear the check box and click OK to disable the numeric heading display.
  5. 5. Verify column letters: Return to the worksheet and confirm that the headings now display as A, B, C.
Restores A, B, C column headings without rebuilding the worksheet.Opens and saves .xlsx files with full Microsoft Excel compatibility.Free, lightweight spreadsheet application with a familiar interface.No data or formula loss when changing the reference style.
QA img-9

Frequently Asked Questions

Why do my Excel column headings show numbers instead of letters?

This happens when R1C1 reference style is enabled. Turn it off in Options or Preferences to restore alphabetic column headings.

Does turning off R1C1 reference style affect formulas or data?

No. It only changes how cell references are displayed. Formula results and stored values are not changed.

Where is R1C1 reference style in WPS Office Spreadsheets?

Click Menu > Options, select General, and clear the R1C1 reference style check box.

Will the alphabetic headings remain if I reopen the file in Excel?

Reference style is application-specific. If Excel still has R1C1 enabled, you need to clear it in Excel Options as well.

Can I edit the same .xlsx file in WPS Office after changing this setting?

Yes. WPS Office Spreadsheets opens and saves .xlsx files, so you can continue working with the same format.