Forum Discussion
Edit dropdown menu on Check Register Excel 1 template
I downloaded the Excel 16 Template called Check Register with Chart 1. I would like to edit the drop down menu under the word category. How do I edit the drop down men?
Fantastic example of a template that's not designed for flexibility. There was a table hidden off in column P--I've unhidden it in this revised one.
You'll still need to use Data Validation to extend the range of choices you have, but at least now you can see it. The other thing you might want to look at--there are named ranges of cells (this table of Categories was one of them). To see the existing names, go on the main menu to "Insert....Name....Define"
Feel free to come back if you have additional questions.
Thank you for posting. Is there a way to add a catergory to the drop down menu list as well?
It probably is, but I would truly suggest looking for another template. Or creating your own.
How experienced are you with Excel?