ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Columns are Numbered rather than lettered? (https://www.excelbanter.com/new-users-excel/167448-columns-numbered-rather-than-lettered.html)

Firman

Columns are Numbered rather than lettered?
 
All of my columns in my worksheets suddenly have come up with numbers rather
than the traditional letters. What went wrong and how do I correct this?

OssieMac

Columns are Numbered rather than lettered?
 
Hi,

Pre xl 2007 versions: Select menu item Tools-Options-General tab and
uncheck R1C1 reference style.

If using xl2007 then click the microsoft button top left of screen, select
Excel Options towards bottom right of dialog box then formulas and it is
under Working with formulas.
--
Regards,

OssieMac


"Firman" wrote:

All of my columns in my worksheets suddenly have come up with numbers rather
than the traditional letters. What went wrong and how do I correct this?



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

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