Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,295,628
Community Members
 
Community Events
165
Community Groups

Copy and Paste Multiple Table Cells

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?

2 answers

1 vote

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. 

0 votes

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/

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence

Confluence: Where work and wellness meet

Feeling overwhelmed by the demands of work and life? With a 25% increase in the prevalence of anxiety and depression worldwide during the pandemic, for most of us, it’s a resounding yes . 🙋‍♀️ ...

927 views 13 27
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you