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.
Cause
This behavior occurs when the R1C1 reference style check box is selected in the Options dialog box.
Under Working with formulas, click to clear the R1C1 reference style check box (upper-left corner), and then click OK.
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.
More information
A1 Reference Style vs. R1C1 Reference Style
The A1 Reference Style
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. For example, D50 refers to the cell at the intersection of column D and row 50. To refer to a range of cells, type the reference for the cell that is in the upper-left corner of the range, type a colon (:), and then type the reference to the cell that is in the lower-right corner of the range.
The R1C1 Reference Style
Excel can also use the R1C1 reference style, in which both the rows and the columns on the worksheet are numbered. The R1C1 reference style is useful if you want to compute row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number.
References
For more information about this topic, click Microsoft Excel Help on the Help menu, type about cell and range references in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
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.
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.
Note. Apart from the A1 reference style, where columns are defined by letters and rows by numbers, there also exist the R1C1 reference style where both rows and columns are identified by numbers (R1C1 designates row 1, column 1).
Click in a cell to the left or right of where you want to add a column. On the Layout tab, do one of the following: To add a column to the left of the cell, click Insert Left in the Rows and Columns group.To add a column to the right of the cell, click Insert Right in the Rows and Columns group.
What is the maximum limit of rows in Excel? Microsoft says that the maximum size of a single Excel spreadsheet is 1,048,576 rows by 16,384 columns. The maximum row height is 409 points, and the maximum column width is 255 characters.
The correct answer is 63. MS Word or Microsoft Word is a text editing software. In MS Word, the user can insert a table by clicking on the insert tab. The maximum column that can be inserted in a table is 63.
Select the column that's immediately to the right of the last column you want frozen. Select the View tab, Windows Group, click the Freeze Panes drop down and select Freeze Panes. Excel inserts a thin line to show you where the frozen pane begins.
Hobby: Web surfing, Skiing, role-playing games, Sketching, Polo, Sewing, Genealogy
Introduction: My name is Maia Crooks Jr, I am a homely, joyous, shiny, successful, hilarious, thoughtful, joyous person who loves writing and wants to share my knowledge and understanding with you.
We notice you're using an ad blocker
Without advertising income, we can't keep making this site awesome for you.
