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 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.

Ctrl

Shift

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

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

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.10. 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.