M
Martha
In excel, how can I change the column titles from numbers
back to the usual letter?
back to the usual letter?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
kraljb
Tools: Options: General: Uncheck 'R1C1 Reference Style
B
Biff
Goto Tools>Options>General Tab
Uncheck R1C1 reference style
Biff
Uncheck R1C1 reference style
Biff
G
Guest
Here is the info/fix:
The R1C1 reference style
You can use a reference style where both the rows and the
columns on the worksheet are numbered. The R1C1 reference
style is useful for computing row and column positions in
macros. In the R1C1 style, Excel indicates the location of
a cell with an "R" followed by a row number and a "C"
followed by a column number.
To turn R1C1 reference style on or off
Click Options on the Tools menu, and then click the
General tab.
Under Settings, select or clear the R1C1 reference style
check box.
The R1C1 reference style
You can use a reference style where both the rows and the
columns on the worksheet are numbered. The R1C1 reference
style is useful for computing row and column positions in
macros. In the R1C1 style, Excel indicates the location of
a cell with an "R" followed by a row number and a "C"
followed by a column number.
To turn R1C1 reference style on or off
Click Options on the Tools menu, and then click the
General tab.
Under Settings, select or clear the R1C1 reference style
check box.