asked on Show Row and Column Number in Excel
Using Excel 2010, how can I show the numeric POSITION value of the Row and Column of a cell I select? Note I'm not talking about the value of the data stored in that Cell, but rather the position of the cell itself.
For example, if I select cell B5, then the Column would be 2 and the Row would be 5. That's simple enough to do, but some of the sheets I've been working with lately have a lot of columns and rows, and it would be nice if I could know at a glance that Column AQ is number 34 (or whatever column it is).
I see where I can enable the R1C1 reference style in the Options dialog, but that makes it more difficult to work with formulas and I'd prefer not to use that, or toggle back and forth between those two views. I suppose I could have two sheets, one set to each view, but then I have to manage changes across those two and I don't really want to do that.
Is there some setting that shows me the current Row and Column numeric position value, similar to the way Visual Studio tells me the Row and Column of my cursor's current location? Any addins that will do that, or am I just missing a feature of Excel?
For example, if I select cell B5, then the Column would be 2 and the Row would be 5. That's simple enough to do, but some of the sheets I've been working with lately have a lot of columns and rows, and it would be nice if I could know at a glance that Column AQ is number 34 (or whatever column it is).
I see where I can enable the R1C1 reference style in the Options dialog, but that makes it more difficult to work with formulas and I'd prefer not to use that, or toggle back and forth between those two views. I suppose I could have two sheets, one set to each view, but then I have to manage changes across those two and I don't really want to do that.
Is there some setting that shows me the current Row and Column numeric position value, similar to the way Visual Studio tells me the Row and Column of my cursor's current location? Any addins that will do that, or am I just missing a feature of Excel?
Microsoft ExcelMicrosoft OfficeMicrosoft Access
Last Comment
Scott McDaniel (EE MVE )
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Works perfectly - thanks.
Peter - yours shows the Column, but not the Row
Peter - yours shows the Column, but not the Row
Private Sub Workbook_SheetSelectionCha
Application.StatusBar = ActiveCell.Column
End Sub