Next cohorts · Spreadsheet Fundamentals: Part 1 · Jan 11
Back to blog
SpreadsheetsJun 1, 2023Katie Fifer

Macabacus Shortcuts

Save time in Excel with an easy-to-use shortcut plugin. We recommend heavy PC Excel users invest in Macabacus to speed up their workflow.

Save time in Excel with an easy-to-use shortcut plugin

We recommend heavy PC Excel users (including people who work in finance, private equity, FP&A) invest in a shortcut plugin. Macabacus is one of the easiest ones to get started with, and it's also affordable. You can either watch the full video walk-through, or scroll down for specific clips on the relevant sections.

Macabacus overview (YouTube)

Why use Macabacus?

Three main features that we use most often (although there is plenty of other functionality in the tool as well).

  • Formatting shortcuts: Easy to configure and easy to cycle through for quick color formatting, font style, centering, borders and other key formatting needs
  • Step through a formula: Ability to easily trace precedents and dependents across tabs
  • Exporting to PowerPoint or Word: Keep all of your data easily refreshed through a simple click

How do I install and setup Macabacus?

You will need to install the Macabacus plugin from the Macabacus website. You can do so either from their pricing page or try a 14-day free trial.

Once you have that installed, you can import our recommended Macabacus shortcut settings. To do so, go to our google drive folder here and download and save the file titled "MacabacusSettings-Recalc.xml" to your computer (do not open). Once you have saved down the file, go to Excel > Macabacus > Settings > Import > Import from xml. Then select the file from wherever you saved it. Once that's done, you'll have uploaded our shortcuts and are ready to start saving tons of time in Excel!

How do I view, edit and configure my keyboard shortcuts?

To view your existing keyboard shortcuts, go to Macabacus settings > keyboard shortcut manager. This will show us all of our shortcuts as they exist today. You'll notice that every shortcut is a combination of control, alt, shift and another character. Not every shortcut uses all of those characters, but you can use any combination of those four. Whatever is shown in dark gray is what you're using. If you ever want to change the key combination for a given shortcut, simply click or unclick any of the control, alt, shift, character elements for that shortcut. Macabacus will warn you if you're trying to use a shortcut key combination that is already used elsewhere.

If you want to edit the specifics of what each shortcut does, you will need to go to Macabacus settings > configure. This view will show us all of the functionality and allows us to change it. You should not need to do this on a regular basis, but just useful to know in case you do need to change something.

What are the most useful shortcuts?

Below is a snapshot of our most commonly used shortcuts.

Recalc shortcut keysShortcut description
Ctrl Shift CFont color cycle (blue, green, purple, red, white, black)
Ctrl Shift VFill cell color cycle (blue, gray, yellow, orange, dark blue, no fill)
Ctrl Shift GDark blue with white bolded text
Ctrl Shift NNumber cycles (accounting, month-year, full date, dollar sign number format)
Ctrl Shift PPercent number cycle
Ctrl Shift MCenter alignment cycle (align center in a cell, center across selection)
Ctrl Shift UUnderline cycle (regular underline, single accounting, double accounting)
Ctrl Shift FCenters across selection and single accounting underline (for headers)
Ctrl Shift HCenters across selection and single accounting underline in date format (for headers)
Ctrl Shift BTop border cycle (single line, dotted line)
Ctrl Shift 6Toggle formatting
Ctrl Shift 7Outer border

Tracing Precedents & Dependents

Tracing precedents lets you step through each piece of a formula in more detail, including across tabs.

Tracing dependents reviews all of the things that are dependent on this cell (all of the cells that this cell drives).

Exporting to PowerPoint & Word

With the professional version of Macabacus, you can paste from Excel directly into PowerPoint or Word, with the ability to easily refresh your data on the click of a button.

What if I have CapIQ and the shortcuts are overlapping?

If you have CapIQ, you should disable CapIQ quick keys. To do so, go to S&P Capital IQ > Customize > Settings. In the settings dialog box, click on "General" and check "Disable Capital IQ Quick Keys" and click OK. Restart Excel.

Browse more articles.

Explore more tips, guides, and insights to sharpen your skills.