Style + Grouping

Hi,

1. I have got too many "Style" on an Excel model and I cannot remove them. Some of them are locked and when I want to delete them, they duplicate. Could you please suggest what would be the best way to delete all of them including the ones that are locked. It is possible to untick the box "locked" but by doing so, they duplicate and the duplicate ones are locked.

2. On one excel spreadsheet, I cannot either group or ungroup. However I can do so in the other spreadsheets from the model. Do you have an explanation for that and do you know how to fix this?

Thank you in advance for your help.

Regards.

Have you tried changing the 'style' back to 'normal'? This will remove all 'styles'

Hi Greed,

Thank you for your message. However, by changing the 'style' back to 'normal' does not allow me to remove all the 'style' from the list. I would like to know how to remove them as some of them are locked and cannot be removed. Instead they duplicate.

Furthermore, do you know why on one Excel spreadsheet, I cannot either group or ungroup rows?

Thank you in advance,

Regards

It depends - can you attach it so I can see what you mean?

Are any portions of the workbook protected? That can also cause issues