ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the column headings in Excel? (https://www.excelbanter.com/excel-discussion-misc-queries/18904-how-do-i-change-column-headings-excel.html)

scmagnum

How do I change the column headings in Excel?
 
I have a new computer at work and when I opened excel, i found the columns
are labeled with numbers, just like the rows. This is very confusing. How
do I change them back to letters like it should be?

Bob Phillips

Go to ToolsOptionsGeneral and uncheck the R1C1 Reference Style checkbox.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"scmagnum" wrote in message
...
I have a new computer at work and when I opened excel, i found the columns
are labeled with numbers, just like the rows. This is very confusing.

How
do I change them back to letters like it should be?





All times are GMT +1. The time now is 05:37 PM.

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