top of page

Key Features

Improve your accuracy and speed in Google Sheets with our essential toolkit for finance, strategy, and operations professionals

Formula Auditing 

Trace precedents

Trace Precedents

  • See all the cells referenced in your formula in one view

  • Quickly jump to every precedent cell using the up and down arrow keys

  • Make spreadsheet edits without having to close the trace precedents window

  • Dive a layer deeper and view the precedents of the precedents cells from the same window without having to rerun the tool

  • Close the window by hitting "Esc." Never need to touch your mouse!

  • Similar to the tracing precedents tools seen in plug-ins like Macabacus, Arixcel, Factset, and S&P Capital IQ on Excel

Trace Precedents on Google Sheets like Macabacus and Arixcel on Excel

Trace Dependents

  • See all the cells that reference the cell that you’re on in one window

  • Navigate to every dependent cell using the up / down arrow keys

  • We've optimized the tool for speed, and if there is a time-out due to the complexity of the spreadsheet, we'll let you know and return anything that we've already found

  • Close the window by hitting "Esc." Never need to touch your mouse!

  • Similar to the trace dependents tools seen in plug-ins like Macabacus, Arixcel, Factset, and S&P Capital IQ

Trace Dependents on Google Sheets like Macabacus and Arixcel on Excel

Format Cycles

Number Cycle
General number cycle

General Number Cycle

  • Apply custom number formats to selected cells quickly

  • Use our shortcut once, and "Format 1" will be applied to the selection. Use our shortcut again while still on the same selection, and "Format 2" will be applied. Use it again and "Format 3" will be applied. There are 4 formats that you can cycle through

  • All formats are completely customizable, meaning you'll be able to apply any format you want to your selection quickly and without a mouse

  • Some users would like multiple cycles because they want cycles specific to percentages, multiples, currencies, etc. We provide cycles for all of these number types (i.e., Percent Cycle, Multiples Cycle, Local Currency Cycle) and they work the same way as General Number Cycle 

General Number Cycle on Google Sheets similar to Macabacus on Excel
Font Color Cycle

Font Color Cycle

  • Apply font colors to selected data 

  • Most users use this to quickly color-code different data types in their sheet

    • Blue = Hardcode​

    • Green = Formula uses an input from another tab 

    • Red = A one-off formula adjustment or an error to return back to

    • Black = Formula

  • Use our shortcut once, and "Color 1" will be applied to the selection. Use our shortcut again while still on the same selection, and "Color 2" will be applied. Use it again and "Color 3" will be applied. There are 4 formats that you can cycle through

  • All colors are completely customizable, meaning you'll be able to apply any format you want to your selection quickly and without a mouse

Font Color Cycle
Font Color Cycle on Google Sheets similar to Macabacus on Excel
Fill Color Cycle

Fill Color Cycle

  • Apply fill colors to selected cells 

  • Most users use this to apply company colors to their analysis 

  • Use our shortcut once, and "Color 1" will be applied to the selection. Use our shortcut again while still on the same selection, and "Color 2" will be applied. Use it again and "Color 3" will be applied. There are 4 formats that you can cycle through

  • All colors are completely customizable, meaning you'll be able to apply any format you want to your selection quickly and without a mouse

Fill Color Cyce
Cell Fill Color Cycle on Google Sheets similar to Macabacus on Excel

Excel Shortcuts on Google Sheets

Excel shortcuts Google Sheets

We support the following Excel shortcuts 

  • Insert Columns / Rows:  Ctrl + Shift + "+" 

  • Delete Columns / Rows: Ctrl + Shift + "-" 

Insert & Delete Columns & Rows on Google Sheets using the Excel shortcut

  • Paste Special:  Alt/Option + E + S . This will bring up a menu with the following options

    • Formulas​:  Alt/Option + E + S + F 

    • Values:  Alt/Option + E + S + V 

    • Formatting:  Alt/Option + E + S + T 

    • Transposed:  Alt/Option + E + S + E 

Paste Special, including Paste Formulas, Paste Values, Paste Formatting, on Google Sheets using the Excel shortcut

  • All Border Shortcuts

    • Top Border: ​ Alt/Option + H + B + P 

    • Bottom Border:  Alt/Option + H + B + O  

    • Left Border:  Alt/Option + H + B + L 

    • Right Border:  Alt/Option + H + B + R 

    • Outside Border:  Alt/Option + H + B + S 

    • All Border:  Alt/Option + H + B + A 

    • Inner Border:  Alt/Option + H + B + I 

    • Horizontal Border:  Alt/Option + H + B + Z 

    • Vertical Border:  Alt/Option + H + B + V

    • Remove Border:  Alt/Option + H + B + N â€‹

Add and Remove Borders on Google Sheets using the Excel shortcuts

  • Resize Rows & Columns

    • Set Column Width:  Alt/Option + H + O + W 

    • Autofit Columns:  Alt/Option + H + O + I 

    • Set Row Height:  Alt/Option + H + O + H 

    • Autofit Rows:  Alt/Option + H + O + A 

​

Autofit Column Width, Autofit Row Height, Set Column Width, Set Row Height on Google Sheets using the Excel shortcuts

  • Alignment

    • Align Center​:  Alt/Option + H + A + C 

    • Align Left:  Alt/Option + H + A + L 

    • Align Right:  Alt/Option + H + A + R 

​​

Align Center, Left, and Right on Google Sheets

  • Increase Decimals:  Alt/Option + H + 0 

  • Reduce Decimals:  Alt/Option + H + 9 

Increase and Reduce Decimals on Google Sheets using the Excel shortcuts

  • Add/Remove Filters:  Ctrl + Shift + L 

Add Filters Remove Filters Shortcut.gif

Customizable Shortcuts

Custom Shortcuts
customizable shortcuts

All shortcuts are customizable. If you prefer a shortcut instead of the one shown as the default, you may change it by clicking the key you'd like to change

Customize Shortcuts on Google Sheets
bottom of page