Functions How to Lock Cells and Use Absolute References in Excel Locking cells in Excel is one of the most useful features in Excel. Absolute references and horizontal and vertical range locking allow you to enter a formula once and use …