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

Cellereferencetyperne A1 og R1C1

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  Knappen Generelle indstillinger .

  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.

Del Facebook Facebook Twitter Twitter Mail Mail

Var disse oplysninger nyttige?

Fantastisk! Har du mere feedback?

Hvordan kan vi forbedre det?

Tak for din feedback!

×