change category template excel

New Contributor


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 Replies
best response confirmed by Bauwelaer13 (New Contributor)

@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.

Many thanks! It worked!