ExcelBanter - Excel Format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel Format (https://www.excelbanter.com/excel-discussion-misc-queries/58487-excel-format.html)

Can the column references - A B C, etc. and row reverence - 1 2 3, etc be
changed?

Can the column references - A B C, etc. and row reverence - 1 2 3, etc be
changed?

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 :P

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 WindowFreeze
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 ToolsOptionsView and uncheck
"row and column headers".

Gord Dibben Excel MVP

On Fri, 2 Dec 2005 14:51:01 -0800, "2701Ray"
wrote:

Can the column references - A B C, etc. and row reverence - 1 2 3, etc be
changed?