Forum Discussion
Excel Table "Total Row" Settings
Hello,
I am wondering if there is a way to change the default settings when using the "Total Row" function of an Excel Table. By default, the "Total Row" automatically sums the last column of the table. I would like the "Total Row" by default to sum every column in the table. Is there a way to change the "Total Row" settings to accomplish my goal?
You can copy the formula across the total row to either return sums or other aggregated values.
