Excel cell reference

Copper Contributor

Which of the following is correct option in MS-Excel 365, if a value in a cell of column A and row 10 is to be referred in a function or formula?

Options -

1. A-10

2. A:10

3. A10

4. 10A

1 Reply


You can easily check this by selecting the cell in column A, row 10. Look at the name box on the left hand side of the formula bar.