Microsoft Excel displays all cell references by default. When you click on a cell, its column and row references are highlighted in the worksheet's column and row headings. Excel also displays the cell reference in the "Name Box," which is a text box that displays in the sheet's formula bar. You can hide cell headings as well as the formula bar, and you can restore these labels to find hidden cell references as needed.
Launch Excel and click "View" on the ribbon.
Check the "Formula Bar" box in the ribbon's "Show" group.
Check the "Headings" box in the ribbon's "Show" group.
Click any cell. Excel highlights the relevant column heading and row heading in amber, and the cell reference appears in the Name Box.
- Stockbyte/Stockbyte/Getty Images