×
英语
很抱歉。本文没有你的语言版本。

My column headings are labeled with numbers instead of letters

Cause: The default cell reference style (A1), which refers to columns as letters and refers to rows as numbers, was changed.

Solution:    Clear the R1C1 reference style selection in Excel preferences.

Difference between A1 and R1C1 reference styles

A1 and R1C1 cell reference styles

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  General Preferences button .

  3. Clear the Use R1C1 reference style check box.

    The column headings now show A, B, and C, instead of 1, 2, 3, and so on.

扩展你的 Office 技能
了解培训
抢先获得新功能
加入 Office 预览体验计划

此信息是否有帮助?

谢谢您的反馈!

谢谢你的反馈! 可能需要转接到 Office 支持专员。

×