Worksheet Tools

Worksheet Tools

Navigator: The Navigator provides a number of functions to work with and move between open Workbooks and their associated Worksheets. Note: The Navigator does not function with Workbooks with multiple document windows in the same Workbook.

When opened, the Navigator displays all currently opened Workbooks in the Workbook Pane. The active Workbook is selected and the visible Worksheets are displayed in the Worksheet Pane with the active Worksheet selected. To display a different Workbook or Worksheet, select the appropriate item and then double click. The Navigator will display the selected Workbook or Worksheet.

Workbook Functions:

       ❷Sort Workbooks: Sorts the list of Workbooks in the Workbook Pane -  Ascending or Descending.

       ❸View 2 Workbooks: Displays the active Workbook and one other highlighted Workbook – Side by Side. The other workbooks are minimized.

       ❹Stretch Across Monitors: Essentially maximizes the active Workbook across multiple monitors.

       ❺New Workbook: Opens and New Workbook and activates it.

       ❻Open Workbook: Opens a file dialog to choose another Workbook to open. It makes it the active Workbook.

       ❼Close Workbook: Closes the highlighted Workbook. If the highlighted Workbook is the active workbook, no action is taken.

       Close: Closes the Navigator form.

Worksheet Functions:

①Sort Worksheets: Sorts the list of Workbooks in the Workbook Pane -  Ascending or Descending and the actual Worksheets in the Workbook.

②New Worksheet: Adds a New Worksheet after the currently selected Worksheet and activates it.

③Hide Worksheet: Hides the currently highlighted Worksheet.

④Unhide All Worksheets: Unhides all hidden Worksheets in the active Workbook.

⑤Delete Worksheet: Deletes the highlighted Worksheet.

       Close: Closes the Navigator form.