Still seems like I am guessing at what you want.
If you want a drop down that can toggle between Paid and Not Paid.
1. Convert the range A2:F5 into an Excel table
2. Put the drop downs in column E
Note that when a new row is added to the table the dropdown will added also.
Let us know if you have any questions.
Bookmarks