Formatting Spreadsheet Cells
Contents
Cells or cell ranges within a spreadsheet in FCS Express may be formatted much as spreadsheets in Microsoft Excel (Figure 5.196).
Figure 5.194 - The spreadsheet layout tab provides access to a number of formatting and specialized features for spreadsheets in FCS Express.
The available formatting categories and options from the Layout tab are:
Font |
Adjust fonts, font sizes, font styles, font color, and cell borders |
Alignment |
Adjust text alignment for horizontal and vertical placement. Indent text. Wrap text within cells. Merge and unmerge selected cells. |
Tokens |
|
Formatting and Sorting |
A range of values may be conditionally formatted or sorted. |
Cells |
Insert or delete rows or columns in the data set. Format cells to autofit contents, hide or unhide contents, and launch the Format Cells dialog. |
Editing |
Clear the contents formatting or contents of cells. Add or remove freeze panes to the spreadsheet. Create a comment to be associated with the selected cell or cell range. |
Show |
Show or Hide the cell borders (Gridlines) or row / column labels (Headers) of the spreadsheet. |
Additionally, Number, Alignment, Font, Border, Fill and Protection from cells or a range of cells may all be adjusted (Figure 5.197). Cells or cell ranges may be formatted via a right click on the select or via the Spreadsheet tab→Layout tab commands. To format a cell or range of cells:
1. Select a cell or range of cells to format
2. Right click within the range.
3. Choose Format Cells.
4. Choose the formatting feature you would like to adjust from the available tabs just as you would do in Excel.
Figure 5.195 - The Format Cell dialog for spreadsheets in FCS Express. The formatting contains all of the familiar features and functionality of Microsoft Excel.
Alternatively:
1. Select a cell or range of cells to format
2. Click on the Spreadsheet tab→Layout tab.
3. Choose the formatting item you wish to apply to the cells.