Can I copy a hierarchy of indented rows without having to expand it first?

Peter Donnelly

How can I copy a hierarchy of indented rows without having to expand it?

 

The hierarchy includes hundreds of indented rows and I want to clone it many  times within the same sheet.

 

Many thanks.

Peter

Brett Evans

If you expand all the rows and then select and copy the rows it works for me.

JamesR

Peter,

 

You cannot copy Hidden rows.  If the Hierarchy is in Collapsed mode, the rows are hidden.

 

Create another Identical sheet that has one Hierarchy with all the rows and leave them Expanded.

Select the rows in the new sheet and either copy and pase them or RMB - Copy to another sheet.

Careful if they have formulae, copy and move do not copy or move the formulae only the result.

Copy and paste will copy formulae except where you have used Absolute Cell Referencing ($ signs)

 

James

jpzeeb

Sure would be nice to have this feature. As a person who tries to limit the amount of "clicks", it takes to get a task done the default process for copying a hierarchy of indented rows is very tedious.