Home

Sheet protection on an excel spreed sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-356057%22%20slang%3D%22en-US%22%3ESheet%20protection%20on%20an%20excel%20spreed%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-356057%22%20slang%3D%22en-US%22%3E%3CP%3EI%20built%20an%20estimating%20program%20and%20I%20have%20selected%20cells%20to%20remain%20unlocked.%20I%20have%20also%20created%20groups%20in%20the%20data%20tab%20to%20open%20and%20close.%20How%20can%20I%20protect%20the%20sheet%20and%20not%20lock%20the%20groups%20at%20the%20same%20time%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-356057%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Huff13579
Occasional Visitor

I built an estimating program and I have selected cells to remain unlocked. I have also created groups in the data tab to open and close. How can I protect the sheet and not lock the groups at the same time?

Related Conversations
Excel on iPad
Mattlewis in Excel on
2 Replies
Help with excel
Alexvez01098 in Excel on
10 Replies
Rotate data from single cell to vertical listings
WEI_Bob in Excel on
2 Replies
2 Seniority Lists
Aminam20 in Excel on
9 Replies
Conditional formatting with wildcard
Rajeev_Raghavan in Excel on
2 Replies