Hide/Unhide rows or columns

You can hide or unhide dynamically by the action.

../../../../_images/img_01.en14.png

Hide Rows

  1. Drag ‘Hide Rows’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the rows to hide.
../../../../_images/img_02.en13.png

Unhide Rows

  1. Drag ‘Unhide Rows’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the rows to unhide.
../../../../_images/img_03.en8.png

Change the rows to Hide/Unhide

  1. Drag ‘Change the rows to Hide/Unhide’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the rows to change to Hide/Unhide.
../../../../_images/img_04.en7.png

Hide Columns

  1. Drag ‘Hide Columns‘ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the rows to hide.
../../../../_images/img_05.en6.png

Unhide Columns

  1. Drag ‘Unhide Columns’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the columns to Unhide.
../../../../_images/img_06.en5.png

Change the columns to Hide/Unhide.

  1. Drag ‘Change the columns to Hide/Unhide’ action from ‘Cell Operation’ tab, then set in the edit area.
  2. Set the columns to change to Hide/Unhide.
../../../../_images/img_07.en4.png

Tip

It is unable to execute the case like the action to hide the row which is already hidden.