How do I allow users to view grouped rows while still protecting d

E

eswack

I used the group & outline feature to take several rows and "group" them
together so that on the far left side of the sheet it has a + sign that when
selected drops down the grouped rows. I need to protect the cells in this
sheet as they are filled with formulas but when I protect the sheet it no
longer allows the viewers to view the grouped rows. How do I protect the
sheet while still allowing viewers to drop down those rows?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect Formulas while deleting rows 1
protecting formulas without protecting sheet so grouping still wor 1
Using Grouped Rows in Protected Worksheet 3
How to promote/demote Excel rows to new outline group level? 0
Method for protecting cells which still allows quick editing 2
How to use outline data (grouped rows) in a protected worksheet? 0
Allow user to insert rows on protected worksheet 1
How can i stop users inserting and unhiding rows and columns my workbook 0

Top