|
![]() |
![]() |
Apply some style and colors Spreadsheets are easier to read when we introduce some background colors and styles. To do that open The Cell Style and Cell Format Inspectors (Select Tools->Inspector from the menu or click on the icon on the Toolbar). These two are used to inspect and change the contents of a cell, this will reflect 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. In our SampleCompany we have used orange as a background color for the row containing month names, blue for the rows containing number entries for the widget and gadget sales and purple for the Total sum. To create this look first open inspectors, select The Cell Style or Cell Format Inspectors. Next place your mouse above the rectangular box inside Cell Format Inspector, see arrow pointing to the box above. Once you click on the border of the box, the color well will appear.( You can also open the color well using the menu Tools ->Colors.) The colors may be changed by dragging and dropping a color chip into the appropriate 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 to the worksheet. To apply some style to our text we use font well. Use the Sheet Inspector to change the default font for the entire sheet. Use the Cell Format Inspector to change the font for the selected range. The fonts may be changed by dragging and dropping a font chip into the appropriate font well, or by dragging and dropping a color chip onto the cell or range directly on the worksheet. Open the font panel by double-clicking on the Font well, or with the menu Format->Font. Click the Preview button to see the result in the font viewer. If you like what you see, click the Set button and your font will be applied to the cell range you specified. See also:
|
||
|
||