Is there a way to break up a table?

[Doris Dunn]

I inserted a large table with numerous rows that I'd like to separate into multiple tables with fewer rows. Wondering if there is an easy way to do this.

[Scott Theus · Accepted solution]

Hi Doris,

Unfortunately, no..the only way to do that is to create the new tables and cut/past the rows from the large table. I've found that Confluence works like adding tables to Word documents.

-Scott

[Doris Dunn]

That's what I thought. My biggest frustration is that I can only copy and paste one cell at a time. Is there a way to grab multiples cells and copy those into the new table?

[Scott Theus]

Try copying the whole think into Excel and then use the Excel sheet as a source for the smaller tables. If that doesn't work I'll play with it a bit in my test space.

[Doris Dunn]

That doesn't work either, as it copies everything into a single column. 

[Scott Theus]

I figured it out...

You have to use the "Copy" and "Paste" buttons in the toolbar. Select the rows you want to copy in the source table and click the Copy button, then put the cursor in a row on the destination table and click the Paste button.

Why the short-cut CTRL-C and CTRL-V don't do this is beyond me.

-Scott

[Manon Soubies-Camy _Modus Create_]

Hello Doris,

Have you tried using the "Copy table row" and "Paste table row" buttons?

• Copy :

• Paste :

You can use it to copy and paste several rows.

Hope this helps,

- Manon

Edit: posted my reply before seeing @Scott Theus's one :)

[Doris Dunn]

Thanks, everyone! Very helpful!

[Marquos Samuel]

Probably this it too old but the Excel trick worked. If you copy an excel table you can paste as table-formatted directly in confluence