Make a macro Ctrl t  which should automatically calculate sum and make sum bold & have border as follows

 

Make a macro to calculate sum & change its format - Macros

Download File and Try:

View Answer

Why Relative references?

If we do not use relative references, it will select same cells while doing sum.


Why should we adjust

Go Ad-free
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 14 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.