Software

Ask something
Discussion Locked

Protecting Excel Formulas

0 helpful
3 replies

by jwalker7

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am in the process of creating a time sheet in Excel for employees at my job, and am wondering if there is any way to protect Excel Formulas, but at the same time allowing the user to insert a row on the same line a protected formula is on?

Any help is appreciated...

3 replies

by dklippert

Choose the cells you do NOT want to protect, then go to Format>Cells>Protection and remove the check mark from locked. Now when you use Tools>Protection>Protect sheet the cells that still have a check mark will be locked.

This discussion is closed to new replies.