Workbook and Worksheet Basics


A workbook consists of worksheets that are divided into rows and columns forming a matrix of cells. You may enter data or formulae into cells. The active cell is highlighted with a rectangular border, you can move the active cell by clicking on another cell with the mouse or by using the cursor keys (arrows).



Tabs are similar to the tabs that stick up in a filing cabinet to help you identify and get to a folder. StatsDirect uses tabs towards the top of the main StatsDirect window to identify workbooks, if you click on one of these tabs then the workbook it identifies is selected as the active workbook. The tab of an active workbook shows bold back text on a while background whereas the tab of an inactive workbook has a grey background. When you hover over the tab of a workbook that has been saved to disk, the path and file name of the workbook will be displayed.


Workbooks also use tabs within themselves, this time towards the bottom of the workbook. Workbook tabs identify and enable you to select worksheets within workbooks. If you double click on the tab of a worksheet then you can re-name it.



Usually, you do most of your work in one worksheet at a time. This is called the active worksheet. When you have multiple worksheets in a workbook, you can use the mouse to click on a worksheet’s tab to make it the active sheet. The tab is highlighted and moves on top of the other tabs.


You can save time and effort by performing some tasks on several sheets at once. For example, if you want all three worksheets in your workbook to have the same title information, you can select all three worksheets and enter the titles on the active worksheet. The titles are automatically entered in the corresponding cells in the other selected worksheets as well.


To select multiple worksheets in the Workbook Designer, use one of the following key/mouse combinations, depending on whether you want to select adjacent or non-adjacent worksheets:



You can insert one or more sheets at a time and at any point in the sheet tab list. The number and position of the inserted sheets depends on number and position of the selected sheets in the workbook.

  1. Select the worksheet immediately to the right of where you want to insert the new worksheets.
  2. Select as many worksheets to the right of that worksheet as the number of worksheets you want to insert. For example, to insert two worksheets, select two worksheets.
  3. Select menu item Insert_Sheet.



You can delete one or more worksheets from the sheet index list by selecting the sheet(s) you want to delete and then selecting the menu item Edit_Delete Sheet.



StatsDirect provides a default name for each worksheet (Sheet 1, 2, etc.). You can change these names to more meaningfully describe the sheets’ contents. For example, the sheet names in the following illustration are more descriptive than the worksheets’ default names. To name a worksheet either double click on the tab of that worksheet or select that worksheet and then select the 'Name' box from via the menu item Format_Sheet Settings. The whole workbook can be renamed by right clicking on its upper tab and using the naming dialog.



You can display or hide different parts of worksheets. You may hide the column and row headings and the gridlines. You may display the worksheet at regular size, shrunk down, or enlarged. You may also choose how many rows and columns you want to display. The default number of rows and columns displayed is the maximum (65,536 rows by 256 columns). You may display fewer. Rows and columns beyond the display limits you specify will not be seen, but they can hold data and formulas. Finally, you may specify how you want to display formulas. Note that StatsDirect does not permit you to hide zero values.


When formulas are displayed, the worksheet automatically doubles the width of columns to accommodate the wider text. When the Formulas option is later unselected, column widths return to their original settings.


To change display options for worksheets:

  1. Select the worksheet(s) whose display settings you want to change.
  2. Select the menu item Format_Sheet Settings and click the View tab.
  3. Select the worksheet and data viewing options you want by selecting or unselecting the options.



You can navigate within individual worksheets using mouse actions or keyboard commands.



Copyright © 2000-2016 StatsDirect Limited, all rights reserved. Download a free trial here.