Power Up Microsoft Excel 2010/2007 With Macros & Hotkeys


Macabacus Macros is a free add-in for Excel 2010/2007 and Excel 2003 that adds various tools and keyboard shortcuts to speed up the construction of financial models. According to the developer, it can trim the time required to perform common tasks by upto 75%.

Unlike other add-ins, it doesn’t install automatically. You will have to first copy the downloaded file to C:\Program Files\Microsoft Office\Office12\Library and then head over to Excel Options and select View Add-ins tab. From here, next to Manage, select Excel Add-ins and hit Go.

Excel Options

From here, check Macabacus Macros add-in and hit OK.

Enable Excel Add-Ins

Note: The above installation method works with MS Office Excel 2010 and Excel 2007 only. To install it in Excel 2003, see the guide on developer’s page.

Restart Excel and you will find the newly added Macabacus tab. It contains small tools to speed up the tasks, I have shown some in the screenshots below.

Macabacus Formatting Excel

formulas macro excel

harvey balls macros excel

To view the hotkeys and edit them to suit your working style, hit the Hot Key Manager button.

Hotkey manager excel

You can tweak the Color Cycles, Font AutoColor, Borders, Numbers, Alignment, and other options from Macabacus Settings dialog.

Macabacus Settings ExcelIt might not come handy to average Excel user, but will surly help those heavy Excel power users.

Download Macabacus Macros Add-in

It works with Excel 2003, Excel 2007, and Excel 2010. Enjoy!

  • Tima

    Thanks for this post, I’m very interested in all connected with MO2010. I just would like to ask you to post an article concerning Microsoft Office 2010 Tech Preview ( if you’re using one from Microsoft as a beta tester). The thing is that I also got invitation from Microsoft to test their MO2010 Tech Preview, and I’m working with it, but the thing is that in 14 days MO2010 will become unlicensed. Could you tell me please what I supposed to do- either uninstall MO2010 completely or continue testing it..? And what functions are going to be switched off after my license expires..?

    • I am using Technical Preview for the last 2 months and it has not expired yet. It only shows the feedback dialog after every 10 minutes or so which wouldn’t be much of a problem. But if you are considering removing older version of Office to install MO2010, then don’t.