Protect only certain cells/ formula from everything except input changes

Please purchase the course before starting the lesson.

Another form of protection is to protect certain cells from accidental or purposeful changes. This protection level stops everything except allowing you to enter information into a cell. You can’t format cells, insert or delete columns or rows, use Pivot Tables or anything else. This can be added to a spreadsheet that is workbook protected or not.

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