ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN. (https://www.excelbanter.com/excel-worksheet-functions/179310-how-do-i-convert-r1c1-referece-style-spreadsheet-a1-referen.html)

afritex

HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN.
 


Cimjet[_2_]

HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN.
 
Hi Afritex
Menu, Tools/Options/General/Settings - unselect R1C1
Regards
Cimjet
"afritex" wrote in message
...



Tyro[_2_]

HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN.
 
You must first pose your question in the body of a message and then stop
yelling (use of capitals)


"afritex" wrote in message
...




Jonah

HOW DO I CONVERT R1C1 REFERECE STYLE SPREADSHEET TO AN A1 REFEREN.
 
Tools, Options, General tab and then uncheck setting for R1C1


Jonah




All times are GMT +1. The time now is 07:25 PM.

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