Log in. Options Help Chat with a consultant. Include archived documents. This content has been archived , and is no longer maintained by Indiana University. Information here may no longer be accurate, and links may no longer be available or reliable. For more information about this change, read this blog post. Your column labels are numeric rather than alphabetic. For example, instead of seeing A, B, and C at the top of your worksheet columns, you see 1, 2, 3, and so on.
This behavior occurs when the R1C1 reference style check box is selected in the Options dialog box. If you select the R1C1 reference style check box, Excel changes the reference style of both row and column headings, and cell references from the A1 style to the R1C1 style.
By default, Excel uses the A1 reference style, which refers to columns as letters A through IV, for a total of columns , and refers to rows as numbers 1 through 65, These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number. This Excel tutorial explains how to change column headings from numbers 1, 2, 3, 4 back to letters A, B, C, D in Excel with screenshots and step-by-step instructions.
Question: In Microsoft Excel , my Excel spreadsheet has numbers for both rows and columns. If your spreadsheet shows the columns as numbers, you can change the headings back to letters with a few easy steps. In the example below, the column headings are numbered 1, 2, 3, 4 instead of the traditional A, B, C, D values that you normally see in Excel.
0コメント