ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Columns showing numerically (https://www.excelbanter.com/excel-discussion-misc-queries/36002-columns-showing-numerically.html)

Sam Riepe

Columns showing numerically
 
My columns are now listed numerically instead of by alpha characters. How do
I get my alpha columns back?

Gary Brown


Select Tools Options, then select the General tab and uncheck the option


R1C1 refernce style

click on OK


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=388320


Bernard Liengme

Tools | Options; open the General tab; locate the box "R1C1 reference style"
and click to add check mark
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sam Riepe" <Sam wrote in message
...
My columns are now listed numerically instead of by alpha characters. How
do
I get my alpha columns back?




Gary L Brown

ToolsOptionsGeneral
Unselect 'R1C1 Reference Style'
HTH,
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Sam Riepe" wrote:

My columns are now listed numerically instead of by alpha characters. How do
I get my alpha columns back?



All times are GMT +1. The time now is 07:13 PM.

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