ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how can i change column to read a.b.c.etc and not 1.2.3. (https://www.excelbanter.com/excel-discussion-misc-queries/81832-how-can-i-change-column-read-b-c-etc-not-1-2-3-a.html)

Column Chris

how can i change column to read a.b.c.etc and not 1.2.3.
 
columns reads as 1 2 3 4 as do the rows, how can i get columns to read a b c
etc making financial spreadsheet building easier?

Bondi

how can i change column to read a.b.c.etc and not 1.2.3.
 
Hi

Tools - Options - General and here remove marking on R1C1 reference
style.

Regards,
Bondi


David Biddulph

how can i change column to read a.b.c.etc and not 1.2.3.
 
"Column Chris" <Column wrote in message
...
columns reads as 1 2 3 4 as do the rows, how can i get columns to read a b
c
etc making financial spreadsheet building easier?


Tools/ Options/ General
Unset "R1C1 reference style"
--
David Biddulph




All times are GMT +1. The time now is 02:20 PM.

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