Hiding Rows and Columns

Figure 1. Education Level table
Education Level table

Some of the data that is displayed in a table may not be useful or it may unnecessarily complicate the table. Fortunately, you can hide entire rows and columns without losing any data.

  1. If it's not already activated, double-click the Education Level table to activate it.
  2. Click Valid Percent column label to select it.
  3. From the Edit menu or the right-click pop-up menu, choose:

    Select > Data and Label Cells

  4. From the View menu, choose Hide or from the right-click pop-up menu choose Hide Category.

    The column is now hidden but not deleted.

    Figure 2. Valid Percent column hidden in table
    The Education Level table with the Valid Percent column hidden.
  5. To redisplay the column, double-click on the same table.
  6. Click View and select Show All Catagories.

    The rows can also be hidden and re-displayed in the same way as columns.

Next