- Why are my column headings numbers instead of letters?
- How are columns labeled in an Excel worksheet?
- How do I label rows and columns in Excel?
- How do I title a column in Excel?
Why are my column headings numbers instead of letters?
Solution: Clear the R1C1 reference style selection in Excel preferences. On the Excel menu, click Preferences. 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.
How are columns labeled in an Excel worksheet?
By default, Excel uses the A1 reference style, which refers to columns as letters (A through IV, for a total of 256 columns), and refers to rows as numbers (1 through 65,536). These letters and numbers are called row and column headings. To refer to a cell, type the column letter followed by the row number.
How do I label rows and columns in Excel?
If your goal is to label columns or rows in your worksheet, just click a cell, type the text that you want to use, and then press TAB to move to the next cell. For example, you might label monthly sales numbers by entering the month names in cell A1 through L1.
How do I title a column in Excel?
Select a column, and then select Transform > Rename. You can also double-click the column header. Enter the new name.