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:




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




  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.




  1. Close the Paste Special form by OK button.




  1. The structures are pasted without the hidden rows.



Back to index page