(ORG-7937)
Sample OPJ to download to try: Copy Paste Formula and Column Label Rows.opj
We have introduced more options to the Copy context menu for columns:
...
- Select one or multiple worksheet column(s)
- Right-click on the worksheet column, there are context menu items available under Copy
- Choose the desired context menu
- Select the worksheet column(s) in the same worksheet or other worksheets.
- Select the destination column(s) and Ctrl+V or right-click and choose Paste from the shortcut menu.
...
- Highlight Col(E1) and Col(F1) in Book1
- Right click and select "Copy: Copy (formula)" from the context menu
- Highlight Col(C) and Col(D) in Book2
- Right click and select Paste from the context menu
