ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   nedd to change column headings from numbers back to letters (https://www.excelbanter.com/new-users-excel/124055-nedd-change-column-headings-numbers-back-letters.html)

chucklinda525

nedd to change column headings from numbers back to letters
 
Myd efault column headings seemed to have changed to numbers instead of
letters. Row headings are ok, row headings are all numbers. How do I
convert the column headings back to letters.

Bernard Liengme

nedd to change column headings from numbers back to letters
 
Use Tools | Options and open the General tab
Top item is "Use R1C1 reference style": unselect this
happy new year

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"chucklinda525" wrote in message
...
Myd efault column headings seemed to have changed to numbers instead of
letters. Row headings are ok, row headings are all numbers. How do I
convert the column headings back to letters.




chucklinda525

nedd to change column headings from numbers back to letters
 
This worked, thanks for your quick response!!

"chucklinda525" wrote:

Myd efault column headings seemed to have changed to numbers instead of
letters. Row headings are ok, row headings are all numbers. How do I
convert the column headings back to letters.



All times are GMT +1. The time now is 12:51 AM.

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