ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to change rows, columns to alpha numerical (https://www.excelbanter.com/excel-discussion-misc-queries/143757-how-change-rows-columns-alpha-numerical.html)

KPM

How to change rows, columns to alpha numerical
 
The column and row labels/titles in excel are now both numerical instead of
alpha numerical. The top left hand cell reads R1C1 instead of A1. How do I
change it back?


David Biddulph[_2_]

How to change rows, columns to alpha numerical
 
Tools/ Options/ General
Uncheck: R1C1 reference style.
--
David Biddulph

"KPM" wrote in message
...
The column and row labels/titles in excel are now both numerical instead
of
alpha numerical. The top left hand cell reads R1C1 instead of A1. How do
I
change it back?




Mike H

How to change rows, columns to alpha numerical
 
Try:-

Tools|Options|General and un-check R1C1

Mike

"KPM" wrote:

The column and row labels/titles in excel are now both numerical instead of
alpha numerical. The top left hand cell reads R1C1 instead of A1. How do I
change it back?



All times are GMT +1. The time now is 02:26 AM.

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