Getting Started
- Preface
- Installation Instructions
- Activation & Licensing
- General Usage Tips
- Update Notes
- Upgrading to v9
Configuration
- Initial Setup Guide
- Color Palettes
- Standard Sizes
- Presentation Templates
- Manage Settings
- Share Settings
Excel Tools
- Formatting
- Rows & Columns
- Sheets
- Formulas & Data
- Financial Modeling
- Auditing
- Charting
- Super Find
- Publishing
- View & Interface
- File Operations
- Cell Comments & Notes
- Keyboard
- Undo / Redo
- Soft Disable
- Performance
- Export to PowerPoint / Word
- Libraries
PowerPoint Tools
- Presentation Automation
- Import from Excel
- Link to Excel
- Linked Slides
- Presentation Proofing
- TurboShapes
- Shape Tools
- Text Tools
- Colors
- Tombstones
- Airplane Mode
- Libraries
Word Tools
Troubleshooting
Account Management
Excel
Rows & Columns
All tools for working with rows and columns can be accessed from the Macabacus > Cells menu, or using shortcuts, as applicable.
Shortcut tip
Default keystrokes to manipulate columns are generally the same as those used to manipulate rows, but additionally include a Ctrl key press.
Cell Size
Row Height Cycle
Cycle through customizable row heights. Repeat the keystroke to apply the next row height in the cycle.
AutoFit Height
Adjust selected row heights to fit cell contents. While Excel always AutoFits hidden rows natively, Macabacus lets you always AutoFit, never AutoFit, or prompt to AutoFit hidden rows.
Column Width Cycle
Cycle through customizable column widths. Repeat the keystroke to apply the next column width in the cycle.
AutoFit Width
Adjust selected column widths to fit cell contents. While Excel always AutoFits hidden columns natively, Macabacus lets you always AutoFit, never AutoFit, or prompt to AutoFit hidden columns.
Resize to Standard Size
Proportionally resize column widths and/or row heights of selected cells such that their cumulative dimensions match those of a pre-defined Standard Size. Select a Standard Size on the Macabacus > Cells > Resize To > Standard Size menu.
Resize to PowerPoint Selection
Proportionally resize column widths and/or row heights of selected cells such that their cumulative dimensions match those of the selected PowerPoint shape. This tool is accessed by clicking the Macabacus > Cells > Resize To > Selection > PowerPoint Selection button.
Resize to Word Selection
Proportionally resize column widths and/or row heights of selected cells such that their cumulative dimensions match those of the selected Word shape. This tool is accessed by clicking the Macabacus > Cells > Resize To > Selection > Word Selection button.
Cell resizing accuracy
Due to Microsoft Office limitations, Macabacus may be unable to size cells to the exact width/height of a Standard Size or PowerPoint/Word selection. Further manual adjustment may be required, perhaps with the help of a guide rectangle. This is because the units of measurement for cells do not convert predictably into standard units of measurement (e.g., inches, points).
Guide Shapes
Guides are rectangle shapes overlaid on your worksheet that provide visual cues for adjusting the sizes of cells manually. To insert a guide, select a size from the Macabacus > Guides menu. Available sizes include customizable Standard Sizes, a selected shape in PowerPoint or Word, or selected cells or charts in Excel.
Copy & Paste
Copy Row/Column Info
Capture row and column information (size, hidden state, and grouped state) from the selected range for pasting to another range.
Paste Row/Column Info
Applies previously captured row and column information (size, hidden state, and grouped state) to the selected range.
Insert & Delete
Insert Row
Insert a new row. If multiple rows are initially selected, the number of rows inserted will equal the number of rows initially selected.
Delete Row
Delete the selected rows. Entire rows do not need to be initially selected. If multiple worksheets are selected, the same rows selected on the active worksheet will be deleted on all selected worksheets.
Delete Blank Rows
Delete blank rows in the selection. If a single cell is initially selected, Macabacus will delete all blank rows on the active worksheet.
Insert Column
Insert a new column. If multiple columns are initially selected, the number of columns inserted will equal the number of columns initially selected.
Delete Column
Delete the selected columns. Entire columns do not need to be initially selected. If multiple worksheets are selected, the same columns selected on the active worksheet will be deleted on all selected worksheets.
Delete Blank Columns
Delete blank columns in the selection. If a single cell is initially selected, Macabacus will delete all blank columns on the active worksheet.
Grouping & Visibility
Group Row
Group selected rows. This operation differs from native grouping in that (a) entire rows do not need to be initially selected, and (b) if multiple worksheets are selected, the same rows selected on the active worksheet will be grouped on all selected worksheets.
This shortcut is disabled by default to avoid conflict with native grouping / ungrouping shortcuts.
Ungroup Row
Ungroup any grouped rows in the selected range. Entire rows do not need to be initially selected.
This shortcut is disabled by default to avoid conflict with native grouping / ungrouping shortcuts.
Hide Row
Group and collapse selected rows. This is generally preferrable to hiding rows natively because the native operation simply sets row heights to zero. Entire rows do not need to be initially selected.
Unhide Row
Expand grouped rows in the selected range. Entire rows do not need to be initially selected.
Expand All Rows
Expand all grouped and collapsed rows on all selected worksheets.
Collapse All Rows
Collapse all grouped rows on all selected worksheets.
Proper Hide
Replace hidden rows/columns (i.e., those with height/width set to zero) with grouped and collapsed rows/columns on all selected worksheets. Grouping and collapsing rows/columns is better practice than simply hiding them because hidden rows/columns are difficult to see and cumbersome to unhide.
Group Column
Group selected columns. This operation differs from native grouping in that (a) entire columns do not need to be initially selected, and (b) if multiple worksheets are selected, the same columns selected on the active worksheet will be grouped on all selected worksheets.
This shortcut is disabled by default to avoid conflict with native grouping / ungrouping shortcuts.
Ungroup Column
Ungroup any grouped columns in the selected range. Entire columns do not need to be initially selected.
This shortcut is disabled by default to avoid conflict with native grouping / ungrouping shortcuts.
Hide Column
Group and collapse selected columns. This is generally preferrable to hiding columns natively because the native operation simply sets column widths to zero. Entire columns do not need to be initially selected.
Unhide Column
Expand grouped columns in the selected range. Entire columns do not need to be initially selected.
Expand All Columns
Expand all grouped and collapsed columns on all selected worksheets.
Collapse All Columns
Collapse all grouped columns on all selected worksheets.
Reverse Columns / Rows
Reverse Columns
Reverse Columns reverses the order of selected columns, using the first row of dates found in the selection as the basis for reordering. This is especially useful for reordering periods in financial statements from oldest to newest or vice versa. For example, financial statements downloaded from the Internet often have the most recent periods on the left, and the oldest on the right. In financial modeling, however, we typically prefer later periods on the right to support projections. Macabacus lets you reverse the order of entire columns, or the order of columns in a smaller selection of cells, only.
Native Excel functionality supports reordering columns similarly, but if any cell formulas refer to the reordered data, those references will be incorrect after reordering. Macabacus, on the other hand, preserves formula references to reordered cells so that columns can be safely reversed, without breaking formulas. This tool is accessed via the Macabacus > Cells > Reverse Columns button.
Reverse Rows
Reverse Rows reverses the order of selected rows, similar to Reverse Columns. This tool is accessed via the Macabacus > Cells > Reverse Rows button.
Batch Modification
Modify Rows
Perform formatting, insertion, and deletion operations on multiple rows at once. For example, you can insert 2 rows every other row for the next 50 rows, apply a certain style to the last of every 3 rows for the next 100 rows, or change the row height of every other row to 5. The Modify Rows tool is most useful when you would otherwise need to manually perform operations on a very large number of rows.
Modify Columns
Modify Columns works the same as Modify Rows, except that it works on columns.
This documentation refers to Macabacus version 9.0.7. Some features and descriptions of these features may not
apply to older versions of Macabacus. Update your Macabacus software to take advantage of the latest features.