All tools for working with sheets can be accessed from the Macabacus > Cells
menu, or using shortcuts, as applicable.
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.
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.
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.
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.
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:
Key the Ctrl+F
shortcut to place the cursor in the search box.
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 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 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.
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.
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.
Unhide all buried sheets in the active workbook to make them visible by clicking the Macabacus > Cells > Buried Sheets > Dig Up Buried Sheets
button.
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.2.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.