Lock Cells but allow column/ row size change

Please purchase the course before starting the lesson.

When you lock cells you need to be particularly careful about how much you lock. If the size of the numbers within a cell may change significantly, a locked spreadsheet may not allow the user to see the numbers as they will appear as ###### and the user won’t be able to resize the column or row.

Lesson tags: vlookup
Back to: Excel for Human Resource and Payroll Personnel > Protecting spreadsheet information and formulas