ExcelBanter - Why are my Excel columns numbered and not alphabetized (A..ZZ)?

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

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

- - Why are my Excel columns numbered and not alphabetized (A..ZZ)? (https://www.excelbanter.com/excel-discussion-misc-queries/162356-why-my-excel-columns-numbered-not-alphabetized-zz.html)

thexdane

Why are my Excel columns numbered and not alphabetized (A..ZZ)?

Opening up Excel the other day, I noticed that the spreadsheet columns were
numbered (1..n) instead the normal alphabetized (A..ZZ). This seems to be a
general setting that I do not know how got changed and thus can't change
back. Any ideas?

Alan

Why are my Excel columns numbered and not alphabetized (A..ZZ)?

Tools Options on the 'General' tab uncheck 'R1C1 reference style'
Regards,
Alan.
"thexdane" wrote in message
...
Opening up Excel the other day, I noticed that the spreadsheet columns
were
numbered (1..n) instead the normal alphabetized (A..ZZ). This seems to be
a
general setting that I do not know how got changed and thus can't change
back. Any ideas?

Gord Dibben

Why are my Excel columns numbered and not alphabetized (A..ZZ)?

ToolsOptionsGeneral.

Uncheck R1C1 reference Style

Gord Dibben MS Excel MVP

On Tue, 16 Oct 2007 15:29:08 -0700, thexdane
wrote:

Opening up Excel the other day, I noticed that the spreadsheet columns were
numbered (1..n) instead the normal alphabetized (A..ZZ). This seems to be a
general setting that I do not know how got changed and thus can't change
back. Any ideas?

All times are GMT +1. The time now is 03:44 AM.