ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I turn off relative cell referencing in excel? (https://www.excelbanter.com/new-users-excel/21732-how-do-i-turn-off-relative-cell-referencing-excel.html)

Glenn

How do I turn off relative cell referencing in excel?
 
Relative cell referencing is currently active. How do I revert back to the
normal cell referencing style of A1 etc.

RagDyer

<Tools <Options <General tab,

And *uncheck* "R1C1 reference style".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Glenn" wrote in message
...
Relative cell referencing is currently active. How do I revert back to the
normal cell referencing style of A1 etc.



All times are GMT +1. The time now is 08:25 AM.

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