ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Columns are numbers (instead of letters). How to revert? XLS (https://www.excelbanter.com/excel-worksheet-functions/140563-columns-numbers-instead-letters-how-revert-xls.html)

bobcat

Columns are numbers (instead of letters). How to revert? XLS
 
In Excel...My rows are still numbers, but somehow columns are also numbers.
So cell A1 is now cell R1C1. How do I revert back?
Version 2003

Dave Peterson

Columns are numbers (instead of letters). How to revert? XLS
 
Tools|Options|General Tab|Uncheck R1C1 Reference style.

Excel will pick this up from the first workbook it opens in that session. You
may want to remember how you changed this setting -- just in case your first
workbook opened has this setting turned on.

bobcat wrote:

In Excel...My rows are still numbers, but somehow columns are also numbers.
So cell A1 is now cell R1C1. How do I revert back?
Version 2003


--

Dave Peterson


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

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