Copying and Pasting Records

When you are entering a lot of records in Datasheet view that are nearly identical, you can use the Windows Clipboard to copy and paste existing records to create new records quickly. After copying and pasting, you can edit individual records to make a few changes. If only part of the record is similar, you can still use the Windows Clipboard to copy and paste the data in a single table cell .

Copy and Paste a New Record

In Datasheet view, right-click the row selector for the row you want to copy.

Click Copy.

Right-click an empty row selector for the new record row.

Click Paste.

Edit the new record as required.

Did You Know?

You can select data to copy . When you select data to copy, you can select an entire row or a single cell, but not multiple cells within a single row.