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

View & Interface

View

Zoom In

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.

Ctrl
Alt
=

Zoom Out

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.

Ctrl
Alt
-

Toggle Gridlines

Toggle gridlines on/off for the selected worksheet(s).

Ctrl
Alt
G

Hide Page Breaks

Hide page breaks on selected worksheets when in Normal View.

Ctrl
Alt
B

Smart Print Area

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.

Ctrl
Alt
Shift
B

Set Print Areas

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

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.

Workspace

Maximize View

Maximize View

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.

Exiting Maximize View

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.

Ctrl
Alt
Shift
W

Excel 2003 Tab

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 Alt>X>T>O.

Excel 2003 Tab

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.