Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.

Footnotes

Toggle Footnotes

Use the Toggle Footnotes shortcut (or menu button) to quickly superscript numbers at the end of cell text, making them appear as footnotes. Repeat the operation to remove superscripting.

Macabacus recognizes footnotes with or without a single space between the last letter in the cell text and the trailing number (e.g., "Other items 2," "Other expense 4"), footnotes encapsulated in square brackets and parenthesis (e.g., "(2)," "[3]") at the end of cell text, and multiple footnotes (e.g., "(2)(3)," "2,3").

When applying superscript formatting natively, Excel may automatically adjust row heights, which can be annoying. Macabacus keeps row height constant when using the Toggle Footnotes tool.

Ctrl
Shift
^

Hide Footnotes

This tool hides footnotes at the end of cell text by changing the font color of the superscripted text to match the fill color of the cell containing the text. The footnote is not actually removed, just hidden. For example, suppose you have added footnotes to your model, but the explanatory text to which the footnotes refer appears on your PowerPoint slide, rather than in your model. If you want to print out your model for review without pasting it into PowerPoint, you can hide the footnotes which do not refer to explanatory text. Access this tool from the Macabacus > Format > Footnotes menu.

Show Footnotes

Show footnotes after hiding them by changing the font color of superscripted text to the font color of the first character in the containing cell. Access this tool from the Macabacus > Format > Footnotes menu.

Footnote Checker

Footnote Checker verifies that footnotes appear in sequential order, such that no numbers are skipped, and also checks the relative positioning of footnotes to ensure that lower numbered footnotes (e.g., 1, 2) appear in top left cells and larger numbered footnotes (e.g., 8, 9) appear in bottom right cells.

You can perform this check on the currently selected range or on all print areas in the active workbook. When you perform this check on all print areas, each print area is inspected individually, so that footnotes in one print area are not compared to footnotes in another print area. You can also specify whether footnotes should be ordered from left to right, then top to bottom, or vice versa.

Note that Macabacus cannot check footnotes in textboxes overlaid on the spreadsheet as they are not part of cell text. Access this tool from the Macabacus > Format > Footnotes menu.

This documentation refers to Macabacus version 8.6.5, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.