Copy or Move a Column from another Sheet
See Also
This menu allows columns to be moved or copied between open spreadsheets. The columns are inserted into the spreadsheet that had focus when this menu menu was invoked.

Get columns from Sheet

This drop down list gives the other currently open spreadsheets whose columns are compatible with (i.e. the have same number of rows as) the current spreadsheet.

Available Columns

This lists the columns in the currently selected spreadsheet. Double clicking columns in this list adds them to the Selected column list. Using the Control or Shift key with the mouse allows the selection of multiple columns.

Selected Columns

This lists columns to be inserted into the spreadsheet. Double clicking columns in this list removes them from this list. Using the Control or Shift key with the mouse allows the selection of multiple columns to be removed. The button places the selected Available columns into the Selected column list. The removes the selected Selected columns from the current list.

Action

Copy columns Copies the selected columns into the current spreadsheet.
Move columns Copy the selected columns into the current spreadsheet, deleting the original columns.

OK

Insert the Selected columns into the spreadsheet and close the dialog.

Apply

Insert the Selected columns into the spreadsheet and keep the dialog open for further changes to be made.

Cancel

Close the dialog without making any further changes.

See Also

Duplicate Column
Spreadsheet Column Menu