Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Show Row and Column Number in Excel

Posted on 2012-03-18
3
Medium Priority
?
1,451 Views
Last Modified: 2012-03-18
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?
0
Comment
3 Comments
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 2000 total points
ID: 37734604
Right-click on the sheet tab name and select view code
Paste this code in the VBA window which appeared.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = "Row " & Target.Row & " ,Column " & Target.Column
End Sub

Close the window
The row/column will be displayed in the status bar.
0
 
LVL 77

Expert Comment

by:peter57r
ID: 37734609
You can put the column number on the status bar using :

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)

 Application.StatusBar = ActiveCell.Column

End Sub
0
 
LVL 85
ID: 37734805
Works perfectly - thanks.

Peter - yours shows the Column, but not the Row
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

972 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question