Make a macro to calculate sum & change its format

Last updated at Dec. 13, 2024 by

 

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:

Sum and Format Macro teachoo.xlsm
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.