Make a macro to calculate sum & change its format

Last updated at July 15, 2026 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

Remove Ads
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant with 16+ years of practical experience and 20+ years of teaching experience. At Teachoo, he simplifies Accounts, Tax and GST with step-by-step examples so students can apply concepts confidently in exams and real life.

For an uninterrupted learning experience, students can use Teachoo Black to remove ads and focus better.