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.

Back to: Advanced Excel Course > Protecting spreadsheet information and formulas