ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Column Headings showing numbers instead of letters (https://www.excelbanter.com/excel-discussion-misc-queries/117843-column-headings-showing-numbers-instead-letters.html)

Sandy M

Column Headings showing numbers instead of letters
 
My boss has an excel spreadsheet that she had been working on.

The in the coordinates row for the columns, it is showing numbers
instead of letters.

How can we get it back to letters?

Thanks,

Bob Phillips

Column Headings showing numbers instead of letters
 
Goto ToolsOptionsGeneral and uncheck R1C1 Reference Style checkbox

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Sandy M" wrote in message
...
My boss has an excel spreadsheet that she had been working on.

The in the coordinates row for the columns, it is showing numbers
instead of letters.

How can we get it back to letters?

Thanks,




Elkar

Column Headings showing numbers instead of letters
 
TOOLS
OPTIONS
GENERAL Tab
Uncheck "R1C1 reference style"
OK

HTH,
Elkar


"Sandy M" wrote:

My boss has an excel spreadsheet that she had been working on.

The in the coordinates row for the columns, it is showing numbers
instead of letters.

How can we get it back to letters?

Thanks,



All times are GMT +1. The time now is 07:10 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com