View Groups On Protected Sheet

  • Is there anyway to view groups on a worksheet that is protected. I have a worksheet that is locked, and I have columns that are grouped, but the user cannot expand the groups when the worksheet is locked. Is there another way I can keep the worksheet locked and still be able to expand my groups?

    Thanks in advance for any help anyone cna provide.


  • Re: View Groups On Protected Sheet

    When protecting the worksheet, will it do what you want if you just leave the box "format columns" checked?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!