Forum Discussion
Solved
change category template excel
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.
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.
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!
