?
Solved

Show Row and Column Number in Excel

Posted on 2012-03-18
3
Medium Priority
?
1,409 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article describes a serious pitfall that can happen when deleting shapes using VBA.
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

752 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