change category template excel

[Bauwelaer13]

How do I change the categories in this excel template "Persoonlijke maandplanner". Now the categories are "work", "thuis"etc, but I can't find where to change this.

[#2 · Accepted solution]

@Bauwelaer13 don't have this particular template at hand now but the categories are in a hidden sheet. You need to unhide the sheet "lijsten" and expand the named range called List_categories. And if I remember correctly, this template is full with conditional formats. You'll have to update these for every new category on every sheet.

[#3]

Many thanks! It worked!