Copy and Paste Multiple Table Cells

Question

Hello,

I have a long table and want to add a column with the same dropdown.

It takes quite long time to copy and paste each dropdown macros to all the cells in the column.

I tried selecting 10 cells with dropdown, Ctrl + Shift + Copy, then go to the 11th row and Ctrl + Shift + V  to paste.

It inserts entire 10 rows, pushing existing rows below.

Is there a way to copy & paste multiple cells?

Elena Ovdienko _Stiltsoft_ · Answer

Hello @Natsuko_Kinoshita ,

You could try our Handy Macros for Confluence app. It allows to create dropdowns anywhere on a page in Confluence, including table cells. You can copy and paste the column you want in empty table cells if needed. Setting up the app is very intuitive for any user, no technicals skills required. Besides the dropdown menu, our app has many features, like Handy Date, Handy Reminder, Handy Tasks, Handy Timestamp, and others.

Julie d_Antin _Elements__bsgnak · Answer

Hi @Natsuko_Kinoshita

Elements Spreadsheet has just released a new version of our advanced table app for Confluence that includes drop-down lists. You can set the choices for a drop-down list and then apply that list to all the cells in a column, for example, and you can create multiple drop-down lists for each table.

You can see what the app looks like in article I just published:

https://community.atlassian.com/t5/Marketplace-Apps-Integrations/Drop-down-lists-filters-custom-colors-and-more-in-Confluence/ba-p/1253949

You can try the app for free for 30 days to see if it meets your needs:
https://marketplace.atlassian.com/apps/1212486/