Forum Discussion
adding ROWS to the spreadsheet https://templates.office.com/en-us/Business-expense-budget-TM04035489
rosbo1 Quite a fancy template. Lots of colors which are almost painful to the eye. But the good thing is that it uses structured tables. On the Start page they suggest this:
On the 2nd sheet there is a note telling you what to do if you want to add rows.
So, on the Planned, Actual and Variances sheets you can add rows within each of the tables but you have to do that in each of the sheets and the inserted rows have to in the same place.
The template gives you four expanse categories, each with its own table in three separate sheets. Then the Analysis sheet links to these tables. If you would want to add an expense category, you need to create a table for it in each of the sheets in a similar way as the current tables. Then add a row to the analysis table, manually link the correct cells and make sure that the graphs are updated correctly. All in all, quite a lot of work for an otherwise not very useful template. But that's just my personal opinion.