Excel Template how to

[HHoward1984]

I got a bit bored at work today and decided to took at the standard templates in excel to see if i could pick up any new tips and tricks. I downloaded this one created by Mircosoft but there is something in it that i cannot work how they have done it


https://templates.office.com/en-us/Simple-personal-budget-TM04035483

on the 'PERSONAL BUDGET' tab it is broken down into categories and at the bottom of each category there is a total. when you go into the total there is a drop down list where you can change the function of the subtotal formula in the cell. Now i know how to achieve the same effect using vlookups and data validation but from the formula you can tell that that is not what they have done. The data validation on the total line is greyed out but the cells don't appear to be locked and the sheet isn't shared so i can't work out how they have achieved this. There are no Macros running or anything else.

whatever method they have used for this it is super tidy so i would like to be able to replicate it.


Any help you can give would be fab

Holly

 

[jkpieterse]

It is a table with a total row. Select anything that looks like a table and then click the Format as Table button on the home tab. Once you've done that, you can turn on the total row (Table tools tab on the ribbon) to get what you describe. Tables have lots of other advatages: https://jkp-ads.com/Articles/Excel2007Tables.asp

 

[HHoward1984]

Thank you so much! So simple but really effective!