Macabacus and Microsoft (for the most part) no longer support Internet Explorer 10 and prior versions. Please consider upgrading your browser.
Zoom in selected worksheets by a specified interval. Repeat the keystroke to continue zooming in. The zoom interval can be set to 5%, 10%, 15%, or 20% in the Application Settings dialog on the Interface tab.
Zoom out selected worksheets by specified interval. Repeat the keystroke to continue zooming out. The zoom interval can be set to 5%, 10%, 15%, or 20% in the Application Settings dialog on the Interface tab.
Toggle gridlines on/off for the selected worksheet(s).
Hide page breaks on selected worksheets when in Normal View.
Set or add the current selection to the print area. If the active worksheet has no print areas set already, the selected range will be set to the print area. If the active worksheet does have other print areas already, Macabacus will ask whether you want to set the selected range as the print area, or add the selected range to the print area. Performing this operation will put the active worksheet in Page Break Preview mode.
Set print areas for all selected worksheets to the address of the currently selected range. Performing this operation will put the selected worksheets in Page Break Preview mode and retain their original zoom levels (Excel randomly changes zoom level when setting Page Break Preview mode). You can select a single range of cells or even multiple non-contiguous ranges. With native Excel functionality, you must set print areas of each worksheet individually. Access this tool from the
Macabacus >View menu.
Remove print areas for all selected worksheets and set their view to Normal. To do this using native Excel functionality, you must remove print areas on each worksheet individually. Access this tool from the
Macabacus >View menu.
Toggle the visibility of various workspace items (e.g., Formula Bar, Status Bar, ribbon, row/column headers, task panes) in Excel's application window to maximize the spreadsheet viewing area. This is especially useful when screen real estate is limited (e.g., laptops). Maximize View is similar to Excel's native Full Screen mode available in some versions of Excel, except that the latter is for presentation only, not editing—pressing the Escape key (necessary in the course of modeling) exits Excel's native Full Screen mode.
You can specify which workspace items Macabacus will hide/show from the Application Settings dialog, and your Maximize View preferences can be loaded upon starting Excel. Some Macabacus notifications and features may not work while the Status Bar is hidden.
If your Maximize View settings hide the ribbon completely, you must use the Maximize View keyboard shortcut to toggle off Maximize View, or restart Excel.
NavAid shades rows and columns intersecting the selected range for improved visibility while navigating cells, and can be enabled / disabled from the
Macabacus > View menu.
NavAid will disable automatically upon saving a workbook, and NavAid clears Excel's Undo stack (an Excel limitation) when enabled. For these reasons, NavAid is generally intended to be used when reviewing models and data, rather than actively building models and populating data.
For users who prefer the easy-to-use Excel 2003 menu/toolbar interface, or those transitioning from Excel 2003 to a newer version, Macabacus recreates the classic Excel 2003 menus and toolbars in a tab on the Ribbon. We preserved most of the familiar Excel 2003 accelerator keystrokes, except you will have to insert one intermediate keystroke, X, in order to activate the Excel 2003 tab. For example, the native
Alt>T>O sequence becomes
This documentation refers to Macabacus version 8.8.16, and may differ from the PDF documentation
on your computer that installed with your version of Macabacus.