Protect only formulas in multiple worksheets at once

[Affialho1]

Hello,
I have an Excel workbook with 30 pages - 28 have formulas in the exact same cells (data will be entered for 12 months/28 separate groups). I need to protect the formulas but have to allow for data entry. Is there a way that I can protect/lock all formulas at the same time, still allowing for user to navigate over all separate months. I'd rather not have to choose the cells with formulas in each worksheet and lock/hide them one set at a time... Any assistance is appreciated. Thanks!

[Mandy11]

Group the sheets and unprotect the cells, then ungroup the sheets and turn protection on.

[Amanda Wilso]

1. Select all cells and then right click and choose format Cells
2. Go to Protection and uncheck locked
3.Then enter the formulas where i need to enter and choose to lock that cell
4. once all done, I would go to Review and choose protect sheet and ensure that check box for protect worksheet and contents of locked cells is checked.


Let’s refer to article in the following thread which discusses about a similar and see if it helps: https://support.microsoft.com/en-us/...in-a-worksheet