Shortcut to Lock Cells in Excel

Shortcut to Lock Cells in Excel and Hide Formulas

The shortcut to lock cells in Excel lies in the F4 key on your keyboard. Once you’ve entered a cell reference in a formula, press F4. This adds a “$” symbol in the field, indicating that the row and column are now locked. By pressing F4 again, only the column will be locked. And by …

Shortcut to Lock Cells in Excel and Hide Formulas Read More »