Working with Dyn-Hide Form

The “Dyn-Hide” dialog lets you dynamically hide information from a report. It allows you to define a cell range on a worksheet that you want to hide.

To hide information:

1. In Microsoft Excel, click Dyn-Hide on the Aspose.Cells command bar.
   The Dyn-Hide dialog is displayed.

2. Edit the hidden information.
3. Click Add to add hidden information.

The defined area is hidden from the report.

To remove hidden information:

1. Select a sheet from the list of hidden areas in the Dyn-Hide dialog.
2. Click Delete.
   The selected area is deleted and will no longer be displayed in the report.