How to change the appearance of empty cells, columns, or rows
1 Right-click a cross tab element. From the menu, choose Options.
2 In Options, complete the following tasks, as shown in
Figure 2‑13:
Select or deselect the following options:
Show empty rows.
Show empty columns.
In For empty cells, show, type a character string to display in empty cells.
Choose OK.
Figure 2‑13 Setting options for empty cells, columns, and rows
In this example, hyphens appear in the previously empty cells, as shown in
Figure 2‑14.
Figure 2‑14 Displaying hyphens in empty cells
