How can I delete or flatten a hierarchy of empty parents without impacting the children cells?

22 views
Skip to first unread message

Vivian Rosa

unread,
Jun 29, 2025, 10:12:20 PMJun 29
to TreeSheets
I'm loving TreeSheets and having a lot o fun playing around with the different ways I can organize information. But when the experimentation leaves me with extraneous parent cells I can't easily delete them and they slowly pile up (Included image is extremely exaggerated for demonstration).

Sometimes `Collapse Cells` or `Flatten work, I'm not sure why. Most of the time they either don't work or they affect every child cell too.

Cutting content cells and pasting them outside the nested grids or over the empty parent nest works, but that resets settings like cell borders and sometimes reflows the pasted grid which isn't always desirable.

I'd love to be able to to just merge or collapse empty cells/grids

TooManyParents.png

Wouter van Oortmerssen

unread,
Jun 30, 2025, 11:14:22 AMJun 30
to trees...@googlegroups.com
I am not sure how you produce all these empty parents, the best way would be to edit without creating them, which is definitely possible.

Maybe you can give the simplest sequence of actions that leaves you with an unwanted parent, and we can figure out a better sequence.

Either way, if you already have a bunch of such parents, I would simply select the inner cells you want to keep, copy, select out parent, paste.

--
You received this message because you are subscribed to the Google Groups "TreeSheets" group.
To unsubscribe from this group and stop receiving emails from it, send an email to treesheets+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/treesheets/89f9e262-171e-4c64-bcb8-13985814f09en%40googlegroups.com.
Reply all
Reply to author
Forward
0 new messages