Spreadsheet (Multimedia Table) Window Overview

1. Select the entire spreadsheet by clicking once in the lower-right corner (the mouse pointer is the default arrow) of the Info Box, which is located in the upper-left corner of the spreadsheet window.
2. To select the Info Box only (for formatting), click once in the upper-left corner of the Info Box (the mouse pointer is an outlined plus sign ).
3. Double-click in the Info Box to enter or edit the text in the Info Box (such as additional details about the spreadsheet). In the preceding illustration, the Info Box contains the text Responses (Peoria, IL).

1. To enter or edit text information, double-click in the Header area, located immediately above the variable headers at the top of the window.
2. To select the Header only (for formatting) click once in the upper-left corner. The mouse pointer displays as an outlined plus sign .
3. Press Ctrl+Enter or Alt+Enter to enter a new line. Note that you need to extend the height of the field to see new lines that you are adding.

In the preceding illustration, the Header contains the text Advertising Effectiveness Study.

In the preceding illustration, the Case Header cells contain the first initials and last names of the respondents in the study.

Double-click on any Case Header cell to enter or edit text information.

• To select a block of case headers (without selecting their respective rows), position the mouse pointer on the left side of the case header cell.
• When Case States are turned off, such as if Display Case States is not checked on the View menu, the mouse pointer is an outlined plus sign .
• When Case States are turned on, the mouse pointer is a magnifying glass ).
• Hold the mouse button down and drag the pointer through the cells for a continuous block of case headers.
• Press the CTRL key on your keyboard to select a discontinuous block of case headers.
  • To select the entire case row (for editing), click once in the middle or right side of the Case Header (the mouse pointer is an outlined plus sign with an arrow ).
  • To autofit the Case Headers, double-click on the far-right side of any Case Header (the mouse pointer is a cross with a double-headed arrow ).

• To select the Variable Header only (for formatting) click once on the upper portion of the Variable Header (the mouse pointer is an outlined plus sign , instead of the ).
• To select the variable column (for editing) click once on the lower portion of the Variable Header (the mouse pointer is an outlined plus sign with an arrow ).
• To autofit the variable column, double-click on the far-right side of the Variable Header (the mouse pointer is a cross with a double-headed arrow ).

In the preceding illustration, the first two Variable Header cells contain the text Gender and Advert. You can change how the Variable Header cells display information so that they show the following options:

• The column number associated with the variable
• The variable long name and an abbreviation of the display types for the variables in the spreadsheet.

Each of these options is available from the View - Variable Headers menu.

• Text in cells can be practically unlimited in length. In most Statistica configurations, text is limited to 1,000 characters to protect against inadvertent pasting of unwanted large amounts of data into one cell.
• Text in cells can be extensively formatted, including using different fonts and font attributes.

See Drag-and-Drop Features for a list of common cell-editing options.

• When hovering your mouse pointer over a cell whose content is not completely displayed, a ToolTip containing the full contents of the spreadsheet cell displays.
• When hovering over a text label, the ToolTip also displays the numeric value of the label.
• When hovering over a cell containing a numeric value displayed as #### (because the column is too narrow) the ToolTip displays the full value of the cell, using the current variable's display format.
• ToolTips are also displayed in the Variable Header and Case Header cells if their contents are not completely displayed.

See also, Spreadsheet Overview.

• To select a block of case headers (without selecting their respective rows), position the mouse pointer on the left side of the case header cell (when Case States are turned off, such as Display Case States is not checked on the View menu, the mouse pointer is an outlined plus sign . When Case States are turned on, the mouse pointer is a magnifying glass .
  • Hold the mouse button down and drag the pointer through the cells for a continuous block of case headers.
  • Press the CTRL key on your keyboard to select a discontinuous block of case headers.
• To select the entire case row (for editing), click once in the middle or right side of the Case Header. The mouse pointer displays as an outlined plus sign with an arrow ).
• To autofit the Case Headers, double-click on the far-right side of any Case Header. The mouse pointer displays as a cross with a double-headed arrow .