The second method is to use the F4 hotkey as the shortcut to lock up a cell. The first method is about assigning the Dollar Sign ($) manually before the column and the row number. In this blog post, two methods to lock a cell in an Excel formula have been discussed with examples. Use the F4 hotkey to lock a cell instantly.
0 Comments
Leave a Reply. |