Sheets
All tools for working with sheets can be accessed from the Macabacus > Cells menu, or using shortcuts, as applicable.
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
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
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
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
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.
Move Sheets
Move Sheets LeftMove 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 RightMove 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 Sheet
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.
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 the latest Macabacus version. 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.