2
2701Ray
Can the column references - A B C, etc. and row reverence - 1 2 3, etc be
changed?
changed?
0
0-0 Wai Wai ^-^
No I don't think so.
You may change it as R1C1 format, but I don't think it is what you want.
Or try non-MS Excel
G
Gord Dibben
Ray
You cannot change the A, B, C headers and 1,2,3 headers.
A workaround is to use Row 1 for a titles row then select A2 and Window>Freeze
Panes so that Row 1 with the titles remains in view when you scroll.
Select B2 instead if you also want Column A to remain in view.
You can turn off the A, B, C, etc. by going to Tools>Options>View and uncheck
"row and column headers".
Gord Dibben Excel MVP
You cannot change the A, B, C headers and 1,2,3 headers.
A workaround is to use Row 1 for a titles row then select A2 and Window>Freeze
Panes so that Row 1 with the titles remains in view when you scroll.
Select B2 instead if you also want Column A to remain in view.
You can turn off the A, B, C, etc. by going to Tools>Options>View and uncheck
"row and column headers".
Gord Dibben Excel MVP