How to Duplicate or Create Recurring Items in Microsoft Lists
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.

- 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.
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.
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.
Navigate to your Microsoft List or SharePoint Online List in your web browser.
Click on the 'Edit in grid view' option located in the top command bar of the list.
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.
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.
Review the duplicated item for accuracy, then click 'Exit grid view' in the top menu to save your changes.

Automate Recurring Items using Power Automate
For items that need to be created automatically on a regular schedule (e.g., daily or weekly maintenance tasks), you can build a scheduled cloud flow.
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. Download and install: Get WPS Office for free from the official website and install it on your device.
- 2. Create a task tracker: Open WPS Spreadsheet and select from a variety of free project management and task tracking templates.
- 3. Manage your data: Use standard shortcut keys and drag handles to duplicate recurring items in seconds.

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.




