Exclude Hidden Rows

Back to index page

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

 

  1. Select some structures on the worksheet after eg. a structure filtering has been applied and select the Home tab, then select the Find & Select|Go To Special menu item:

 

       Menu.GoToSpecial

 

  1. Select the Visible cells only option on the Go To Special form and close the form by OK button.

 

       Form.GoToSpecial

 

  1. Copy the selected structure to the clipboard by Ctrl+C or by selecting the Copy right-click menu item. Change to another worksheet and select the Paste Special right-click menu item or press Ctrl+V.

 

       Menu.RightClick.PasteSpecial

 

  1. Close the Paste Special form by OK button.

 

       Form.PasteSpecial

 

  1. The structures are pasted without the hidden rows.

 

       Cells.PastedStructures.WithoutHidden


Back to index page