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

Formulas & Data

Fast Fill

Macabacus' Fast Fill Right/Down tools are similar to Excel's native Fill Right/Down functions, but far more versatile. With Fast Fill, you need not select the range you wish to fill; Macabacus will automatically determine how far right/down to fill, based on the presence of data surrounding the active cell. Fast Fill will also automatically skip empty spacer columns/rows between columns/rows of data. This tool also integrates and builds upon Excel's Fill Series Dates functionality, letting you enter a wide range of date formats, including those natively supported by Excel (e.g., 4Q13, 2014E, etc.), filling the selected range appropriately.

Fast Fill Right

Intelligently fill data right.

Ctrl
Shift
R

Fast Fill Down

Intelligently fill data down.

Ctrl
Shift
D

Modify Formulas

Error Wrap

Adjust formulas of selected cells to replace errors from existing formulas with custom error messages (e.g., "NM," "NA") or values (e.g., 0) using an IFERROR wrapper. Repeat this keystroke to remove the IFERROR wrapper. Macabacus can prompt you for an error message or value each time, or you can set a default message/value to use automatically. Error Wrap options can be configured in the Excel > Modeling section of the Settings dialog.

Ctrl
Shift
E

Comment Cells

This tool prepends an apostrophe to formulas and numeric inputs in selected cells to make formulas and numbers appear as text. Repeat the Comment Cells shortcut keystroke or click its ribbon button again to remove the apostrophes and restore the original formulas / values.

Ctrl
Shift
'

Clean Cells

This tool trims extraneous spaces from cell formulas and values—double spaces, leading/trailing spaces, spaces between operators, etc. Extra spaces sometimes appear in imported data, preventing you from sorting or otherwise processing data. They can also result in unsightly data/text misalignment that requires correction before publishing. Macabacus cannot remove some extraneous spaces in formulas referencing other workbooks and worksheets.

Additionally, this tool removes worksheet names from formulas where not required. For example, Macabacus will change a formula on Sheet1 that reads =Sheet1!B3 to =B3, since the self-referenced sheet name in the formula is unnecessary.

Ctrl
Shift
L

Unapply Names

Replace defined names in a formula with their corresponding cell references.

Anchor Formula

Anchor each cell reference in selected cells' formulas to the referenced range. Repeat the operation to change the anchor point. For example, =A1, =$A$1, =A$1, =$A1.

Ctrl
F2

Flatten Selection

Convert formulas in the selected range to values and color fonts according to AutoColor settings.

Ctrl
Shift
3

Flip Sign

Invert the sign of numeric inputs and multiply formulas by -1 in the selected range. This is useful when changing the sign convention of expenses in an income statement, for example.

Ctrl
Shift
N

Copy / Paste

Paste Exact

Paste copied cells exactly, preserving original formula cell references.

Ctrl
Alt
E

Paste Number Formats

Paste number formats only.

Ctrl
Alt
F

Paste Transpose

Transpose paste copied cells as links, number formats, or exact formulas.

Ctrl
Alt
T

Paste Duplicate

Paste copied cells preserving original formulas, except to maintain formulaic relativity within the pasted region. This can sometimes be a more intuitive alternative to Paste Exact.

Ctrl
Alt
D

Paste links to copied cells. This is similar to Excel's native Paste Link, except that Macabacus (a) provides a convenient keyboard shortcut, (b) does not paste links to empty cells, (c) more reliably applies number formats from the copied range, and (d) applies AutoColor font colors to the pasted range if AutoColor on Entry is enabled.

Ctrl
Alt
L

Paste Insert

Insert copied or cut cells at the current selection. If you have copied/cut an entire row/column, Macabacus automatically inserts as many rows/columns as are required to accommodate the pasted rows/columns. If you have not copied/cut an entire row/column, Macabacus will prompt you for whether you want to insert rows or columns to accommodate the cells to be pasted.

For example, suppose you cut two entire rows and move the cursor up several rows to your intended insertion point. Upon the Paste Insert operation, Macabacus will insert two rows above the insertion point, paste the cut rows, and delete the original cut rows. Using native Excel functionality, you would have to manually insert the two rows above the intended insertion point before pasting, which involves twice as many keystrokes.

Ctrl
Alt
I

Copy Row/Column Info

Capture row and column information (size, hidden state, and grouped state) from the selected range for pasting to another range.

Ctrl
Alt
J

Paste Row/Column Info

Applies previously captured row and column information (size, hidden state, and grouped state) to the selected range.

Ctrl
Alt
K

Evaluate Functions

Macabacus can replace certain Excel functions within your formulas with the cell references or values to which they evaluate, simplifying formulas and making it easier to understand and audit models. Although Macabacus' formula evaluation tools are extremely effective, Macabacus may be unable to evaluate certain formulas. If Macabacus cannot evaluate a formula, or if the evaluated formula does not produce the same result as the original formula, Macabacus will revert to the original formula and notify you.

Simplify Formula

Replace multiple Excel functions in selected formulas at once with the cell references or values to which those functions evaluate. You can specify which functions Simplify Formula replaces in the Formulas > Evaluate Functions > Options menu.

Ctrl
Alt
Shift
V

Evaluate TRANSPOSE()

Replace a TRANSPOSE formula array with direct links to source cells.

Ctrl
Alt
Shift
T

Evaluate INDIRECT()/INDEX(MATCH())

Replace these Excel functions in formulas with the cell references to which they evaluate.

Evaluate CHOOSE()/OFFSET()/HLOOKUP()/VLOOKUP()/IF()/MIN()/MAX()

Replace these Excel functions in formulas with the cell references or values to which they evaluate.

Min / Max

Go to Min

Go to the cell with the minimum value in the selected range, or if only one cell is selected, in the contiguous range. This is a quick way to find a 52-week low in raw stock price data, for example. You can also access this tool with the Macabacus > Formulas > Go To Min button.

Ctrl
Alt
Shift
,

Go to Max

Go to the cell with the maximum value in the selected range, or if only one cell is selected, in the contiguous range. This is a quick way to find a 52-week high in raw stock price data, for example. You can also access this tool with the Macabacus > Formulas > Go To Max button.

Ctrl
Alt
Shift
.

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