Copy / paste nested rows in the same sheet

Manu
Manu ✭✭✭✭

I can't seem to copy past multiple rows (in the same sheet) when they are folded / nested. Doing so only copies the one top level row.

e.g. If I want to copy the entire project template by selecting the Project Row while it is fully closed, the activities (and all subtasks) do not get copied.

Project

|_ Activity 1

|_ Activity 2


I am forced to open the entire project and shift-select every row to copy then paste below. This is really frustrating, because it means I can't keep a folded "template" at the top of my sheet top be re-used multiple time in the same sheet.

Please tell me there is a good work around?

Best Answer

Answers