|
![]() |
![]() |
The Cell Style and Cell Format Inspectors, used to inspect and change the contents of a cell, reflects the style and formatting information of the current cell. Changes made via the Cell Style Inspector will affect the style of all cells in the current range. The InspectorsEach view contains a button designated " Default." If this is selected, the default format from the current style template is used. If a change is made to the format, the template will be overridden and the new selection will be used for the cell. To go back to using the default item for the cell, click on the Default button. Changes made in the cell style inspector are applied to all cells in the currently selected range. FormatThe format view allows selection of the format used to display the value of the cell. Most items apply only to cells with a number value. Exceptions are the Text and Hidden formats. The Text format displays the input of the cell. If a cell has a formula, the formula - not the calculated value - is displayed. The Hidden format displays nothing in the cell, as if the cell is blank. This format can be used to hide intermediate results that would otherwise clutter the worksheet. Date Int'l 1 displays date serial numbers in the format MM/DD/YY. Date Int'l 2 displays date serial number in the format MM/DD. Time Int'l 1 displays the time portion of date serial number in the format HH:MM:SS. Time Int'l 2 displays the time portion of date serial numbers in the format HH:MM. The decimal selector changes the number of decimal places displayed when Fixed Decimal, Scientific, Currency, Comma, and Percent formats are selected. ColorThe information in cells is displayed in color. Normally, the contents will be displayed in the "Text Color." However, if the value is a negative number, it will be displayed in the "Negative color." The colors may be changed by dragging and dropping a color chip into the appropriate color well. The patterns may be changed by dragging and dropping a pattern chip from the pattern picker into the color well. The text color of a cell or a range of cells can be changed by dragging and dropping a color chip on the cell or range directly on the worksheet. The color picker can be opened by clicking on the border around the color well or with the Tools -> Colors... command. It may be useful to place this command on the Toolbar so that the color picker can be quickly opened. The background or shading of a cell can be changed by Alt-Dragging a color chip. To Alt-Drag a color chip, press the Alternate key before you click on the color well to pick up the color chip. When you drop the color chip on a cell or range, you will not see the color change until you un-highlight it. The background pattern of a cell can be changed similarly. By default, the cell is shaded with the background color of the sheet. To set a background fill, click on the Fill switch. If the background and the shading color are the same, then you will not see a change; however, if you change the background color of the sheet, the cell will retain its color. To change the cell shading, you can Alt-Drag color over the selected cell or range or drop the color in the Shading color well in the Cell Style Inspector. AlignmentUse the Alignment tool to decide on the position of the data within the cell. The Wrap option wraps string information in the cell down so that it does not spill out the sides of the cell, but is displayed on multiple lines within the cell. Smart sets text back to left aligned, and Numbers to right-aligned. FontThis view of the
Cell Style Inspector allows you to change the font by dropping a font
chip in the font well. Open the Font Panel by double-clicking in the
font well, by clicking the button marked Font, or by using the
Format -> Font... (Apple-t) You can underline the contents of a cell by selecting a single, double, or wide line options. Input TypeMesa allows basic checking of data input. Cells can be designated as Numeric, String, Date, or Formula and that cell will accept only input of the designated type. If a cell is typed Any, then any type of data is allowed for input. Unprotected cells are like cells typed any, yet data can be entered into an unprotected cell even when sheet protection is enabled. |
||
|
||