Forum Discussion

Andy710's avatar
Andy710
Copper Contributor
Apr 16, 2022
Solved

Excel Grouping (outline)

Hi all,   Does anyone know how to Group and Un-Group columns in Excel while worksheet locked without using Macros or VBA?  I have a Gantt chart I want to use locking cells I don't want accidentall...
  • iamshyley's avatar
    iamshyley
    Apr 17, 2022

    Andy710 yes sir it's possible, all you have to do is, when you click on the protect sheet, automatically "select locked cells" and "select unlocked cells" are ticked while others are not ticked so you will tick the "format column" or "format rows" depending on where your group is, that way it will be possible to use the group button while sheet is locked.

     

    Hope this helps

Resources