SOLVED

change category template excel

New Contributor

Bauwelaer13_0-1657625221153.png

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

Many thanks! It worked!