'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Duplicate an Item in Microsoft Lists Grid View
Question details
The user wants to duplicate an existing item or copy specific columns in Microsoft Lists while using the Edit in grid view.
- Product
- Microsoft Lists
- Device & OS
- not provided
- Scenario
- Copying an existing list item that is not necessarily the last item in the grid.
- Observed behavior
- The user needs to successfully copy entire rows or individual columns into a new item row using keyboard shortcuts.
Ensure you have the necessary edit permissions for the Microsoft List and that you have opened the list in your web browser.
Duplicate an Entire Item Row Using Keyboard Shortcuts
Use this method to quickly copy an entire existing item into a new row in Microsoft Lists.
You can easily duplicate any record in Microsoft Lists by utilizing the Grid View feature alongside standard copy-and-paste keyboard shortcuts. This method requires selecting the entire row rather than just a single cell.
Click on 'Edit in grid view' at the top menu of your Microsoft Lists page to make the list editable.
Locate the item you want to copy and select the entire row by clicking the circular checkbox on the far left side of that row.
Press 'Ctrl+C' (or Cmd+C on Mac) on your keyboard to copy the selected row data to your clipboard.
Scroll to find the 'Add a new item' row (usually at the bottom), select it, and press 'Ctrl+V' (or Cmd+V on Mac) to paste the duplicated item.
Copy Only Specific Columns in Grid View
Use this method if you only need to duplicate data from a single cell or specific column rather than the entire row.
Boost Your Productivity with WPS Office
While Microsoft Lists handles your specialized tracking needs, WPS Office offers a free, lightweight, and highly compatible alternative to Microsoft Office for your core document, spreadsheet, and presentation tasks.
- 1. Download WPS Office: Visit the official website to download and install WPS Office for free on your preferred device.
- 2. Open WPS Spreadsheet: Launch WPS Spreadsheet to create new data lists or import your existing Excel list data.
- 3. Manage your lists effortlessly: Utilize familiar shortcuts like Ctrl+C and Ctrl+V to manage, duplicate, and analyze your records easily.
Frequently Asked Questions
Can I duplicate multiple items at once in Microsoft Lists?
Yes, in 'Edit in grid view', you can select multiple rows by clicking and dragging across the circles next to the items, then use Ctrl+C to copy and Ctrl+V to paste them into new rows.
Why is the 'Edit in grid view' option missing in my Microsoft List?
The 'Edit in grid view' option might be missing if you do not have sufficient edit permissions, or if the list view has been configured by a site administrator to disable Quick Edit/Grid editing.
Do these keyboard shortcuts work on a Mac?
Yes, on a Mac device, you can use the Command key instead of Ctrl. Press Cmd+C to copy the row or column, and Cmd+V to paste it into the new item row.
