Cut, Copy & Move Elements

How to move OfficeConnect elements within and between rows, columns, and cells.

OfficeConnect provides its own cut, copy, and paste commands that move elements together with their metadata.

Important: Always use OfficeConnect’s own cut/copy/paste commands — not Excel’s standard Ctrl+C/Ctrl+V. Excel’s clipboard doesn’t carry the OfficeConnect element metadata; only OfficeConnect commands do.

Three ways to cut, copy, and paste

Ribbon buttons: Use the functions in the OfficeConnect tab, not the Home tab.

Right-click menu: Right-click the cell, row, or column → OfficeConnect → Cut Elements or Copy Elements, then Paste Elements.

Keyboard shortcuts:

ActionShortcut
CutShift + Ctrl + Alt + X
CopyShift + Ctrl + Alt + C
PasteShift + Ctrl + Alt + V

What you can paste where

Cut/Copy fromCan paste into
CellsCells, rows, or columns
RowsRows or columns
ColumnsRows or columns

Steps

1
Select the source Select the entire row, column, or cell containing the elements you want to move. Highlight the full row or column — not just a few cells within it.
2
Cut or copy Use the ribbon, right-click menu, or keyboard shortcut to cut or copy.
3
Select the destination Highlight the entire destination row, column, or cell.
4
Paste Use the ribbon, right-click menu, or keyboard shortcut to paste.

Append vs replace when dragging

When you drag and drop an element into a location that already has an element:

  • OfficeConnect asks whether to Append (add to existing) or Replace (overwrite existing)
  • Choose Replace to swap one element for another
  • Choose Append to combine elements at that location

Note on merged cells

If your workbook uses merged cells, OfficeConnect cannot update or refresh elements applied to those merged cells. Avoid merging cells that contain OfficeConnect elements.

Next steps

→ Review & Verify Applied Elements to inspect which elements are driving each cell’s data