Creating Tables   «Prev  Next»

Lesson 5 Using Cut, Copy and Paste to enter data more quickly
Objective Enter, edit and copy data in MS Access.

Enter, Edit, and Copy Data in Microsoft Access

The original lesson correctly introduces Cut/Copy/Paste and includes a useful step-by-step image sequence. However, it contains two major issues: (1) outdated UI references (for example, menu paths like Edit >> Copy), and (2) a long detour into Win32 API declarations that does not support the lesson objective. For a modern Access (Microsoft 365 / Access 2021+) workflow, learners need practical datasheet techniques: selecting cells/rows/columns, clipboard behaviors, repeating values, and safe editing patterns. This rewrite keeps the quick-reference table, preserves the full image gallery (each step differs), and removes off-topic API material.

Why Cut, Copy, and Paste matters in datasheets

When you are entering records in Datasheet View, you often repeat values (company names, states, dates, categories). Instead of retyping, you can copy existing values and paste them into new rows and columns. This reduces typing errors and speeds up data entry.

The workflow is consistent across Windows applications:

  1. Select the value (or range of values) you want to reuse.
  2. Copy it to the clipboard.
  3. Move the cursor to the destination cell.
  4. Paste the clipboard contents.

In Access, you can perform these actions using keyboard shortcuts, the Ribbon/Quick Access Toolbar, or the right-click context menu.

Action What it does Keyboard Toolbar button Where to find it
Cut Removes the selected value(s) and stores them on the clipboard Ctrl+X Access Cut Right-click menu or Home tab (Clipboard group)
Copy Copies the selected value(s) to the clipboard Ctrl+C copy to clipboard Right-click menu or Home tab (Clipboard group)
Paste Pastes clipboard content into the active cell Ctrl+V Pastes the contents of the clipboard to the cursor Right-click menu or Home tab (Clipboard group)

Additional productivity shortcut: Ctrl+' (Ctrl + apostrophe) copies the value from the same field in the record above into the current field. This is one of the fastest ways to fill repeating values down a column.

Selecting cells, rows, and columns

Before you copy or cut, you need to select what you want to move:

  • Single cell: click the cell.
  • Multiple adjacent cells: click the first cell, then Shift-click the last cell (or click and drag).
  • Entire column: click the column header.
  • Entire row (record): click the row selector (the gray bar at the left of the row).

Cutting and pasting is especially useful when you are cleaning up records, reorganizing data, or moving values between tables. For larger movements across many records or across multiple tables, importing is often better—but for small changes, clipboard operations are fast and reliable.

Cut, Copy, and Paste in Access (step-by-step example)

Using the clipboard to speed up data entry

1) The first step is to select the text I need and copy it to the clipboard. The first text I need is Network Consultants, Inc. 

| FirstName | Lastname  | Company                   | State     |
| --------- | --------- | ------------------------- | --------- |
| Margaret  | Levine    | Network Consultants, Inc. | AZ        |
| Thorley   | Cook      | Dynamic Solutions, Inc.   | AZ        |
| Christina | White     | Lizard Web, Inc.          | TX        |
| Bill      | Clarke    | XPDX, Inc.                | AZ        |
| Nora      | Sweeney   | MediQual Systems, Inc.    | AZ        |
| Meg       | Young     | Great Tapes, Inc.         | TX        |
| Marcia    | Priestley | Priestley Communications  | CA        |
| Catherine | Molkenbur | *(blank)*                 | *(blank)* |
| Hillary   | Smith     | *(blank)*                 | *(blank)* |
| Piper     | Ronn      | *(blank)*                 | *(blank)* |
1) Select the text you need and copy it to the clipboard. Here, the first value is “Network Consultants, Inc.” Select it by clicking and dragging across the text, then copy it using the Copy button (or Ctrl+C).

2) Nothing changes on the screen to indicate to you that you have stored text on the clipboard.
Rows of the Access table (Customers) 

| FirstName | Lastname  | Company                   | State     |
| --------- | --------- | ------------------------- | --------- |
| Margaret  | Levine    | Network Consultants, Inc. | AZ        |
| Thorley   | Cook      | Dynamic Solutions, Inc.   | AZ        |
| Christina | White     | Lizard Web, Inc.          | TX        |
| Bill      | Clarke    | XPDX, Inc.                | AZ        |
| Nora      | Sweeney   | MediQual Systems, Inc.    | AZ        |
| Meg       | Young     | Great Tapes, Inc.         | TX        |
| Marcia    | Priestley | Priestley Communications  | CA        |
| Catherine | Molkenbur | *(blank)*                 | *(blank)* |
| Hillary   | Smith     | *(blank)*                 | *(blank)* |
| Piper     | Ronn      | *(blank)*                 | *(blank)* |
2) After copying, the datasheet may look unchanged, but the clipboard contains your copied value. Next, copy the state value “AZ” so it is also ready to paste later.

3) As soon as a second piece of text is copied to the clipboard the Clipboard toolbar appears.
3) After copying a second value, the Clipboard toolbar appears and shows multiple stored clips. Next, select “Dynamic Solutions, Inc.” and copy it as well so you can paste it later.

4) The Clipboard toolbar now has three icons, since three pieces of text are stored there.
4) The Clipboard toolbar now shows three stored clips. You can hover over each icon to confirm what it represents. Now you are ready to paste values into the blank cells.
MS Access 365
5) I move the cursor to the Company column for Catherine Molkenbur.
5) Move the cursor to the Company field for Catherine Molkenbur. She works for Network Consultants, so paste that value by selecting the first clip (or paste with Ctrl+V if the correct value is currently active on the clipboard).

6) Next I move the cursor to the State column for Catherine Molkenbur and copy AZ by clicking the second icon on the clipboard toolbar.
6) Move to the State field for Catherine Molkenbur and paste “AZ” using the second clip on the Clipboard toolbar.

7) Hillary works for Dynamic Solutions, so I move the cursor to the Company field for Hillary and click the third icon on the clipboard toolbar to paste that text.
7) Hillary works for Dynamic Solutions. Move to Hillary’s Company field and paste “Dynamic Solutions, Inc.” using the third clip.

8) All I need to do now is put in Hillary's state and Piper's information. Piper also works for Dynamic Solutions.
8) Finish the remaining cells. For repeating values down a column, use Ctrl+' to copy the value from the record above into the current field. This is often faster than repeatedly pasting.

Best practices and common pitfalls

  • Prefer Copy over Cut for initial entry: When you are filling blanks, copying is safer. Cutting is best for moving a value that is currently in the wrong place.
  • Watch data types: If a field is a Number, Date/Time, or Yes/No type, pasted text may be rejected or coerced. If a paste fails, confirm the field datatype in Table Design View.
  • Be careful with multi-cell pastes: When pasting a range, Access expects the pasted shape (rows/columns) to align with the destination selection.
  • Commit the record: Access typically saves a record when you move off the row. After pasting, move to another record to ensure the row is committed.

Cut Copy Paste - Exercise

Enter data into your Clients table in this exercise using Cut, Copy, Paste, and Ctrl+' where appropriate.

Cut Copy Paste - Exercise

SEMrush Software 5 SEMrush Banner 5