Prev < Pivot tables            Next > Export and import data

Enhanced Copy and Paste

Copy and Paste multiple rows between tables:

If pasting multiple rows fails because of table constraints, you can easily fix problematic cells before commiting:

Fixing ID cells that broke table contraints:

Copy and paste directly to/from Excel tables:

Prev < Pivot tables            Next > Export and import data