ExcelBanter - what is the shortcut for freezing ($) linked cells in excel?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - what is the shortcut for freezing ($) linked cells in excel? (https://www.excelbanter.com/excel-discussion-misc-queries/135329-what-shortcut-freezing-%24-linked-cells-excel.html)

lior

what is the shortcut for freezing ($) linked cells in excel?

What is the keyboard shortcut for "locking" linked cells in excel. I.e. A$4$?

David Biddulph[_2_]

what is the shortcut for freezing ($) linked cells in excel?

If you mean toggling between the various combinations of absolute and
relative references, then the key is F4
--
David Biddulph

"lior" wrote in message
...
What is the keyboard shortcut for "locking" linked cells in excel. I.e.
A$4$?

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