1) What are the numerical heading in MS Excel called? How many of them are there?
Answers
Answered by
0
Answer:
Symptoms
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.
Resolution
To change this behavior, follow these steps:
Start Microsoft Excel.
On the Tools menu, click Options.
Click the Formulas tab.
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.
Similar questions