ExcelBanter - What is Excel hotkey for cell lock, C1 to $c$1

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

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

- - What is Excel hotkey for cell lock, C1 to $c$1 (https://www.excelbanter.com/excel-discussion-misc-queries/54593-re-what-excel-hotkey-cell-lock-c1-%24c%241.html)

Duke Carey

What is Excel hotkey for cell lock, C1 to $c$1

the F4 function key

"BLUTO" wrote:

I recall a hotkey that can lock all the cell references in a formula.
ex. A1+B1 to $A$1+$B$1

All times are GMT +1. The time now is 03:22 PM.