Explorer Functionality in Detail

RANGE EXPLORER/RANGE SELECTION

The Number Format, Alignment, Font, Borders, Interior, and Protection in Active Workpapers correspond to the Number, Alignment, Font, Border, Patterns, and Protection in Excel.

Number Format - Defines how numbers display in cells.
Alignment - Defines how entries align in cells.
Font - Defines font characteristics: type, style, size, color, and so forth.
Borders - Defines how cell borders display, including line style and color.
Interior - Defines how the inside of cells appear, including pattern and color.
Protection - Defines how data in cells is treated when a sheet is protected. You can lock cells and hide formulas.
Hyperlink - Used to create hyperlinks to web addresses, email addresses, etc.
Validation - Defines the logic for confirming errors.
Conditional Format - Defines cell formatting based on logic.

 

WORKBOOK EXPLORER

Workbook Set - Provides options for calculation logic and iteration scope.
Book# - Provides options for calculation, window formatting, protection, and shapes.
Sheet# - Defines how a sheet displays and operates, including options for formula display, zero value display, row and column headers, gridlines, protection, and tab color.

Note: Right-click on a worksheet to access the menu options for inserting, copying, deleting, renaming, and hiding worksheets.


Defined Names - Allows you to create names for cell ranges, formulas, and values and use these names in formulas.
Outline - Defines the placement of summary rows and columns in relation to detail rows and columns.
Page Setup - Provides options for printing, print preview, scaling for printing, margins, headers, and footers.
Sheet - Provides options for printing; print preview; defining the print area; printing gridlines, title rows and columns, row and column headers; and designating page order.