Excel for Human Resource and Payroll Personnel

Protect only certain cells/ formula from everything except input changes

You don’t have access to this lesson

Please purchase this course, or sign in if you’re already enrolled, to access the course content.

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.

0 of 137 lessons complete (0%)
0
    0
    Your Cart
    Your cart is emptyReturn to Shop