How do I customise categories and groups in excel.
I have pulled my bank transactions and balances into the workbook but the category tab is all blank.
If it helps my description always has “Payment to Authority…” or “Debit Card Purchase…” or Withdrawal Osko-…" etc.
Your “Categories” sheet is where you define what categories you want to have available, and which groups they are in. Any of the cells in green can be changed to whatever you wish. Once setup, in your Transactions sheet, you should be able to click the drop down arrow in the Category column for each transaction and choose from the categories you created on the Categories sheet.