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

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.

Alt

Shift

Insert

Delete Row

Delete the selected rows. Entire rows do not need to be initially selected.

Alt

Shift

Delete

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.

Ctrl

Alt

Shift

Insert

Delete Column

Delete the selected columns. Entire columns do not need to be initially selected.

Ctrl

Alt

Shift

Delete

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. Entire rows do not need to be initially selected.

Alt

Shift

Ungroup Row

Ungroup any grouped rows in the selected range. Entire rows do not need to be initially selected.

Alt

Shift

Hide Row

Group and collapse selected rows. Entire rows do not need to be initially selected.

Alt

Shift

Home

Unhide Row

Expand grouped rows in the selected range. Entire rows do not need to be initially selected.

Alt

Shift

End

Expand All Rows

Expand all grouped and collapsed rows on the active worksheet.

Alt

Shift

=

Collapse All Rows

Collapse all grouped rows on the active worksheet.

Alt

Shift

-

Proper Hide

Replace hidden rows/columns (i.e., those with height/width equal to zero) with grouped and collapsed rows/columns in the active worksheet. Grouping and collapsing rows/columns is a better practice than simply hiding them.

Ctrl

Alt

H

Group Column

Group selected columns. Entire columns do not need to be initially selected.

Alt

Shift

Ungroup Column

Ungroup any grouped columns in the selected range. Entire columns do not need to be initially selected.

Alt

Shift

Hide Column

Group and collapse selected columns. Entire columns do not need to be initially selected.

Ctrl

Alt

Shift

Home

Unhide Column

Expand grouped columns in the selected range. Entire columns do not need to be initially selected.

Ctrl

Alt

Shift

End

Expand All Columns

Expand all grouped and collapsed columns on the active worksheet.

Ctrl

Alt

Shift

=

Collapse All Columns

Collapse all grouped columns on the active worksheet.

Ctrl

Alt

Shift

-

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.

Sheets

All tools for working with sheets can be accessed from the Macabacus > Cells menu, or using shortcuts, as applicable.

Navigate Sheets

First Sheet

Go to the first sheet in the active workbook. This can be very useful when navigating workbooks with a large number of sheets. You can also access this tool with the Macabacus > Cells > Navigate > First Sheet button.

Ctrl

Alt

Home

Next Sheet

Loop forward through sheets in the active workbook. Repeat the keystroke to continue looping. When keyed on the last sheet in the workbook, this shortcut will navigate to the first sheet. You can also access this tool with the Macabacus > Cells > Navigate > Next Sheet button. We recommend using this shortcut instead of Excel's native Ctrl+Page Down shortcut for navigating between sheets.

Ctrl

Alt

PgDn

Last Sheet

Go to the last sheet in the active workbook. This can be very useful when navigating workbooks with a large number of sheets. You can also access this tool with the Macabacus > Cells > Navigate > Last Sheet button.

Ctrl

Alt

End

Previous Sheet

Loop backward through sheets in the active workbook. Repeat the keystroke to continue looping. When keyed on the first sheet in the workbook, this shortcut will navigate to the last sheet. You can also access this tool with the Macabacus > Cells > Navigate > Previous Sheet button. We recommend using this shortcut instead of Excel's native Ctrl+Page Up shortcut for navigating between sheets.

Ctrl

Alt

PgUp

Activate Sheet

You probably didn't even know that Excel has an Activate dialog that lets you navigate directly to a specific sheet in your workbook. That is because Microsoft buried it deep in the Excel interface, and you have to use the mouse to access it. Although largely inaccessible, the native Activate dialog is extremely useful for navigating workbooks large numbers of sheets. Macabacus improves upon the native Activate dialog with its Activate Sheet dialog, which can be accessed using a keyboard shortcut and includes a search feature for finding the sheet you want quickly. Key the Ctrl+F shortcut to place the cursor in the search box.

Ctrl

Shift

T

Move Sheets

Move Sheets Left

Move selected sheets to the left in the sheet order. This tool can move multiple sheets at a time, including worksheets, chart sheets, or a combination of both. If the left-most selected sheet is the first sheet in the workbook, keying this shortcut will move the selected sheet(s) to the end of the workbook.

Ctrl

Alt

Shift

N

Move Sheets Right

Move selected sheets to the right in the sheet order. This tool can move multiple sheets at a time, including worksheets, chart sheets, or a combination of both. If the right-most selected sheet is the last sheet in the workbook, keying this shortcut will move the selected sheet(s) to the beginning of the workbook.

Ctrl

Alt

Shift

M

Buried Sheets

"Buried" sheets are hidden worksheets and chart sheets that can only be unhidden programmatically—via VBA code or an add-in like Macabacus. Burying a sheet can be useful for hiding information from users of your workbook, but should not be used to protect sensitive information.

Bury Selected Sheets

Hide selected sheets in the active workbook so that they can only be unhidden programmatically by clicking the Macabacus > Cells > Buried Sheets > Bury Selected Sheets button.

Bury Hidden Sheets

Hide all hidden sheets in the active workbook so that they can only be unhidden programmatically by clicking the Macabacus > Cells > Buried Sheets > Bury Hidden Sheets button.

Dig Up Buried Sheets

Unhide all buried sheets in the active workbook to make them visible by clicking the Macabacus > Cells > Buried Sheets > Dig Up Buried Sheets button.

Unhide Sheets

Macabacus replaces Excel's native Unhide dialog used to unhide hidden sheets with an enhanced version that allows you to (a) unhide multiple sheets at once, (b) unhide "buried" (i.e., xlSheetVeryHidden) sheets, and (c) resize the dialog to show more sheets or better view sheets with long names. Access this dialog from any native button normally used to unhide sheets, or from the Macabacus > Cells menu.

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

The leading Microsoft Office productivityadd-ins for finance and other professionals