Can one select multiple rows in a column (or vie versa) and paste once into ALL the rows?
Example. I have a macro (in this case the Handy Status Macro) and I want to put in in all the rows under the column status. Do I really have to paste it into each row?!?!?! really sucks when i have 500+ rows....
Doing this in Confluence 6.5 DataCenter.
That's a good idea. I tested to see if I could find a workaround, like in Excel when you pull the corner of the cell down and it copies the value. I was not able to find such a capability in Confluence, so I opened a suggestion for our development team: As an user, would like to update multiple cells simultaneously in a table
The suggestion is public, so you can vote, comment and watch it to make your voice heard and see if/when the development team implements it.
This is not built-in to Confluence, but there is a work-around:
1. Create a new Google Sheet
2. Paste the data, Google Sheets automatically structures it per row.
3. Copy the data from Google Sheets
4. Paste in Confluence, the data will now be structured per row!