ExcelBanter - How to fix excel columns now in numbers rather than ABC etc?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - How to fix excel columns now in numbers rather than ABC etc? (https://www.excelbanter.com/setting-up-configuration-excel/230676-how-fix-excel-columns-now-numbers-rather-than-abc-etc.html)

Katie B

How to fix excel columns now in numbers rather than ABC etc?

Dave Peterson

How to fix excel columns now in numbers rather than ABC etc?

In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote:

--

Dave Peterson

Katie B[_2_]

How to fix excel columns now in numbers rather than ABC etc?

"Dave Peterson" wrote:

In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote: Unfortunately now on newer version and can't seem to track down the same function! One of the joys of upgrading I suppose!

--

Dave Peterson

Katie B[_2_]

How to fix excel columns now in numbers rather than ABC etc?

"Dave Peterson" wrote:

In xl2003 menus:
Tools|Options|General Tab|
Uncheck the R1C1 Reference style checkbox.

Katie B wrote: Thank you Dave. Prompted me to look at the excel options on my new version and have found the old function now. Many thanks, frustration now solved!

--

Dave Peterson

All times are GMT +1. The time now is 07:23 AM.