Exclude Hidden Rows

It is possible to copy-paste structures without the hidden rows.

To do this, follow the steps below.

  1. Select some structures on the worksheet after, for example, a structure filtering has been applied.

  2. On the Home tab of Excel, click Find & Select > Go To Special.
    images/download/attachments/1806804/Without_Hidden_Rows_1.png

  3. On the Go To Special dialog, select Visible cells only by using the corresponding radio button and click OK to close the dialog.

    images/download/attachments/1806804/Without_Hidden_Rows_2.png

  4. Copy the selected structures to the clipboard by using the Ctrl+C shortcut or the Copy button on the ribbon.

  5. Select another worksheet and invoke the context menu then click Paste Special.
    images/download/attachments/1806804/Without_Hidden_Rows_3.png

  6. On the Paste Special dialog, click OK.
    images/download/attachments/1806804/Without_Hidden_Rows_4.png

  7. The structures are pasted without the hidden rows.

    images/download/attachments/1806804/Without_Hidden_Rows_5.png