1. Home
  2. MS Office

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!

Leave a comment