Forum Discussion

theojkett's avatar
theojkett
Copper Contributor
Apr 06, 2021

Budget Wheel Template

Hey Boys and Girls,

I downloaded the Budget Wheel Template for Excel and it has some built-in labels. Those labels are Home, Entertainment, Transportation, Food, Misc. and Savings. I want to change those to be labels that more apply to what I am doing. For example, I want Misc. to be Credit Cards, Food to be Services. 

 

I can't see a way in Excel to change the labels but maybe I'm missing something.

 

Thank you in advance for your help. Greatly appreciate. 

Go forth and be awesome.

TK

excel

1 Reply

  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Apr 06, 2021

    theojkett 

    The workbook has a hidden sheet named Data that contains the source list for the categories.

    Right-click any sheet tab.

    Select Unhide... from the context menu.

    Select Data and click OK.

    After changing the category description in a cell in A3:A8, you should also edit the formula in the corresponding cell in column B.

    You can also edit the list of frequencies in D3:D9.

    Hide the Data sheet again when you're done.