Others

How to Duplicate or Create Recurring Items in Microsoft Lists

Natalie TaylorNatalie Taylor Nov 3, 2026 869 views

Question details

The user needs to duplicate existing items and set up recurring tasks in Microsoft Lists or SharePoint, which do not have native built-in buttons for these actions.

How to Duplicate and Automate Recurring Items in Microsoft Lists
Product
Microsoft Lists
Device & OS
not provided
Scenario
Managing tasks, schedules, or records where identical entries are frequently needed or occur on a regular schedule.
Observed behavior
Microsoft Lists and SharePoint Online lack a default duplicate-item option and native recurrence settings, requiring manual workarounds or automated flows.
Before you start

Ensure you have edit permissions for the Microsoft List or SharePoint list you are working on, and access to Power Automate if you plan to create recurring scheduled workflows.

Solution 1Recommended

Duplicate Items Using Edit in Grid View

Since there is no built-in duplicate button, using the Grid View is the fastest way to manually copy and paste existing list items.

This method is ideal for quick, manual duplications. It utilizes standard copy-and-paste keyboard shortcuts within the list's spreadsheet-like interface.

1
Open your list

Navigate to your Microsoft List or SharePoint Online List in your web browser.

2
Enter Grid View

Click on the 'Edit in grid view' option located in the top command bar of the list.

3
Copy the target row

Select the row you want to duplicate by clicking on its far-left edge, then press Ctrl+C (Windows) or Cmd+C (Mac) to copy it.

4
Paste as a new item

Scroll to the bottom of the list, click on 'Add new item', and press Ctrl+V (Windows) or Cmd+V (Mac) to paste the copied values.

5
Save changes

Review the duplicated item for accuracy, then click 'Exit grid view' in the top menu to save your changes.

Duplicate Items Using Edit in Grid View
Attachments are not copied: Copying and pasting rows in Grid View will only duplicate text and metadata. File attachments from the original item will not carry over and must be manually uploaded.
Free Microsoft Office alternative

Manage Data and Tasks Effortlessly with WPS Office

If you find Microsoft Lists too rigid for quick task management, WPS Spreadsheet offers a flexible, lightweight, and powerful alternative for data tracking. It is fully compatible with Microsoft Excel formats, allowing you to easily sort, filter, duplicate, and drag-to-fill recurring data without needing complex automated workflows.

  1. 1. Download and install: Get WPS Office for free from the official website and install it on your device.
  2. 2. Create a task tracker: Open WPS Spreadsheet and select from a variety of free project management and task tracking templates.
  3. 3. Manage your data: Use standard shortcut keys and drag handles to duplicate recurring items in seconds.
Free, lightweight, and fast Office suiteFully compatible with Microsoft Excel (.xlsx) formats for easy migrationBuilt-in templates for task tracking, schedules, and project managementSimple drag-and-fill tools to instantly duplicate recurring rows
microsoft office alternative - wps office

Frequently Asked Questions

Why is there no duplicate button in Microsoft Lists?

Microsoft Lists and SharePoint are built around structured database records rather than standard spreadsheet cells. Because database items often have unique IDs, dependencies, or attachments, Microsoft currently requires users to use Grid View or Power Automate workflows to replicate items safely.

Can I duplicate multiple items at once in Microsoft Lists?

Yes. By entering 'Edit in grid view', you can click and drag to highlight multiple rows on the far-left edge, copy them with Ctrl+C, and paste them into new empty rows at the bottom of the list using Ctrl+V.

Will copying a list item in Grid View also copy its attachments?

No, using the Grid View copy-and-paste method only duplicates the text fields and column metadata. Any files or images attached to the original list item will need to be manually uploaded to the newly created item.