Column number
 

Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.

Thanks,

Column number
 

=column(g1)

?????

Or just put
=column()
in any cell in column G.

SpaceCamel wrote:

Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.

Thanks,

--

Dave Peterson

Column number
 

You can have the column letters appear as numbers.
Tools--options--general--R1C1 reference style.

You can also populate the first row of cells with numbers, A1=1, B1, =2,
etc., and freeze that first row. To do this select teh 2nd row, then
Window--Freeze Panes.

Finally, you can use the COLUMN function =COLUMN(D1) returns 4, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"SpaceCamel" wrote:

Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.

Thanks,

Column number
 

Thanks for the suggestions.

I don't want to modify the worksheet.
I was just hoping for a tooltip or statusbar display for quick temporary
reference.


"Dave F" wrote:

You can have the column letters appear as numbers.
Tools--options--general--R1C1 reference style.

You can also populate the first row of cells with numbers, A1=1, B1, =2,
etc., and freeze that first row. To do this select teh 2nd row, then
Window--Freeze Panes.

Finally, you can use the COLUMN function =COLUMN(D1) returns 4, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"SpaceCamel" wrote:

Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.

Thanks,

Column number
 

I was just hoping for a tooltip or statusbar display

One idea...While working on a particular sheet, you could place this code on
that particular sheet module in vba.
It will display the R1C1 address in the status bar.
When you are finished working on the sheet, you could remove it.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.StatusBar = Target.Address(True, True, xlR1C1)
End Sub

--
HTH :)
Dana DeLouis
Windows XP & Office 2003


"SpaceCamel" wrote in message
...
Thanks for the suggestions.

I don't want to modify the worksheet.
I was just hoping for a tooltip or statusbar display for quick temporary
reference.


"Dave F" wrote:

You can have the column letters appear as numbers.
Tools--options--general--R1C1 reference style.

You can also populate the first row of cells with numbers, A1=1, B1, =2,
etc., and freeze that first row. To do this select teh 2nd row, then
Window--Freeze Panes.

Finally, you can use the COLUMN function =COLUMN(D1) returns 4, etc.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"SpaceCamel" wrote:

Is there a quick way to determine the coulmn number, Shortcut?
ie, Column "G" is column 7.

Thanks,