At the moment the worksheet columns only have the corresponding letter at the top. If it were to somehow have the corresponding number equivalent many VB users would appreciate it.
How it could work - while mouse is hovering over the Letter "Z" would display a "26" and so on.2 votes
This is already possible, using R1C1-style references. To enable them,
1. Go to File > Options > Formulas.
2. Under “Working with formulas”, check the “R1C1 reference style” check box
Hope that helps,
- Don't see your idea?