Excel with the 3D Add-in (3D Menu Items)
3D Structural Integrity – Structural integrity is enforced by protecting worksheets (insertion and deletion of rows and columns- disallowed) with all cells in the worksheet unlocked. This is referred to below as “3D protection”.
Worksheet Control – Menu Items – 3D Protect Grouped Sheets, 3D Unprotect and GroupSheets, 3D Reprotect Sheets, 3D Sheet Check
The 3D protection is applied by selecting and grouping some worksheets in the workbook and then selecting the menu item “3D Protect Grouped Sheets”.
The 3D protection can be removed and the worksheets in question grouped by selecting the menu item “3D Unprotect and GroupSheets” (this enables insertion and deletion of rows and columns, and other formatting tasks, for the selected sheets).
To reapply 3D protection to previously protected sheets the menu item “3D Reprotect Sheets” is selected.
To check which sheets are in a 3D group select “3D Sheet Check” – protected sheet tabs are highlighted in black.
3D scrolling – Menu Items – 3D Scroll On for Protected Sheets, 3D Scroll Off
3D scrolling and cell selection is available for protected worksheets.
This can be disabled and re-enabled by selecting the menu items. Disabling 3D scrolling allows the format painter to operate normally.
Freeze Pane – Menu Items – 3D Freeze Pane, 3D UnFreeze Pane
Freeze pane can be applied identically to or removed from all protected worksheets in one operation.
Print Setup – Menu Items – 3D Set Print Area, 3D Set Title Rows, 3D Set Title Columns, 3D Clear Print Settings, ClearPrintSettings
Print settings can be applied identically to or removed from all protected worksheets in one operation.
Worksheet Utilities – Menu Items – Copy Sheet Names to Clipboard, Unhide All Sheets
All of the tab names in the work book can be copied to the clipboard. This is useful for creating an index worksheet or dashboard. Unhide all sheets is a useful utility.
3D to Flat Worksheet Utilities – Menu Items – Vertical Range Find And Replace, Horizontal Range Find And Replace
Vertical / Horizontal Range Find And Replace assist in creating an index worksheet or dashboard.