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
- Slide Tools
- Text Tools
- Colors
- Airplane Mode
- Libraries
- Tombstones
Word Tools
Troubleshooting
Account Management
Excel
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.
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.
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.
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.
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 with many sheets. Macabacus improves upon the native Activate dialog with its Activate Sheet dialog in the following ways:
- Access the Activate Sheet dialog using a convenient keyboard shortcut
- Search feature for finding sheets quickly in a workbook with many sheets
- Resize the Activate Sheet dialog to view long sheet names in their entirety
Key the Ctrl+F shortcut to place the cursor in the search box.
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.
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.
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 and 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 tool is not available in shared workbooks, and Macabacus will revert to the native Unhide Sheets dialog for shared workbooks.
This documentation refers to Macabacus version 9.1.6. 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.