Hiding Cells

You can hide individual cells in your tables where the values are equal to, above, or below a value that you specify. For example, you might choose to hide cells containing values of less than 10. Note that when you hide cells, all the contents of a cell that meets the hide condition are removed, but the cell still remains on the table.

To hide cells

In the Tables pane, select the table that you want to modify.

From the menu, choose:

Choose the Hide tab.

Check the Hide cells box.

In the drop-down list, select the condition for hiding the cell, and enter a value. For example, you might choose to hide cells containing values of less than 10. The default condition hides values less than or equal to zero.

Choose OK to close the Table Properties dialog box, save your changes, and apply them to the current table.

Generate the table to see the results of your changes: