Formatting Table Cells

In Wdesk, you can modify cells so values and text will always display in a particular format. For example, a cell formatted as Currency will display numeric values as dollar amounts with chosen symbols, decimal places, etc.

If you need to add formulas to your table values, this is done in the source data, usually found in a workbook. These values are linked into the table as destination links for data consistency. To learn more see the Using Formulas and the Linking Overview articles.

Basic Table Cell Formatting

To format cells, select them and right-click, then select Format Cells. In the Format Cells dialog box, adjust the options to your preference. Options are available to modify both the cell, such as borders, and the cell's contents, such as leader dots. When finished, click OK.

image alt text

To create borders for table cells, select one or more cells. Right-click and select Format Cells. Click on the Borders & Fills tab. Click on the borders you would like to format in the Border Picker box. Choose your Border Style, Border Weight, and Border Color. Then choose OK.

Leader dots are often used in the first column of a table to help lead the eye from text to numeric data in subsequent columns.

To learn more about leader dots, read the article Creating a Table of Contents and Hyperlinks.

NOTE: Some category-specific options will not appear until the appropriate associated feature has been selected, such as line breaks for dates.

Merging and Splitting Table Cells

To merge cells in a Wdesk table, select the cells you wish to merge. Click the Merge icon and choose Merge Selection from the drop-down menu.

To split a cell or range of cells in a table into multiple cells, select the cell(s) you wish to split. Click the Merge icon and choose Unmerge Selection from the drop-down menu. If the selected range of cells contains multiple values, merging the cells will only keep the top-left data value.

If you have not performed any other actions after a merge or unmerge, you can use the Undo button to return the cells to their original state.

Alternate Row or Column Fill

To create alternate row or column fill in tables in Wdesk, select more than one rows or columns or select the entire table using Select Table from the Table Options icon menu. Then right-click to access the Format Cells dialog box. Choose the Borders & Fills tab and then Fill Style and Alternate Rows. Now choose a fill color and then OK.

To remove the alternate fill if no other actions have been performed, you can use the Undo button in the toolbar. Otherwise, you can select the table or affected columns or rows, return to the Format Cells dialog box by right-clicking and choose None in Fill Style.

Advanced Cell Formatting

Advanced formatting options are also available in the Format Cells window, including custom prefixes and suffixes. These can be accessed from the Values tab under the Advanced listing.

Paragraph Properties for Table Cells

In cells containing text, you can edit the cell's paragraph properties from the Paragraph Properties dialog, found in the right-click menu. This will allow you to adjust options such as indentation or line spacing within the selected cell(s).