(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:

...

• Copy (Formula): Copy Set Column Value settings
• Copy (Label Rows): Copy the column label rows without data
• Copy (Including Label Rows): Copy the column label rows with dataCopy (Formula and Label Rows): Copy both Set Column Value Settings and Label Rows

...

1. Select one or multiple worksheet column(s)
2. Right-click on the worksheet column, there are context menu items available under Copy
3. Choose the desired context menu
   Image RemovedImage Added
4. Select the worksheet column(s) in the same worksheet or other worksheets.
5. Select the destination column(s) and Ctrl+V or right-click and choose Paste from the shortcut menu.

...

1. Highlight Col(E1) and Col(F1) in Book1
2. Right click and select "Copy: Copy (formula)" from the context menu
3. Highlight Col(C) and Col(D) in Book2
4. Right click and select Paste from the context menu

Image RemovedImage Added