Document Editing Problems

Fix Microsoft Lists Copy and Paste Errors in Edit Grid View

WPS Content Manager Oct 12, 2026 871 views

Question details

Users encounter errors when attempting to copy and paste multiple rows or cells in the Edit grid view of Microsoft Lists.

Fix Microsoft Lists Copy and Paste Errors in Edit Grid View

Product: Microsoft Lists
Device & OS: not provided
Scenario: Copying and pasting rows or cells in Edit grid view.
Observed behavior: Copying multiple rows or noncontiguous cells fails, displaying an error message such as 'That command cannot be used on multiple selections'.

Before you start

Before troubleshooting, ensure your browser is fully updated and the Microsoft Lists page has completely loaded to prevent temporary script glitches from interfering with your clipboard actions.

Solution 1Recommended

Limit Selection Size and Use Contiguous Cells

Adjust your selection method to bypass backend limitations in Microsoft Lists that prevent copying large or scattered datasets.

Microsoft Lists often imposes strict limits on clipboard actions within the Edit grid view. Many users find that copying more than a couple of rows triggers a backend defect, and non-adjacent selections are completely unsupported.

Select Fewer Rows

Try copying a smaller batch of rows (e.g., just one or two rows at a time) by clicking and dragging your mouse across them, then test if the copy function works without error.

Select Contiguous Cells

Ensure you are selecting a continuous, unbroken block of cells. Avoid using Ctrl (or Cmd on Mac) to click and select cells that are distributed across different rows or columns.

Execute Copy Command

Once a valid, continuous range of one to two rows is highlighted, press Ctrl+C (Cmd+C) to copy, then navigate to your destination cell and press Ctrl+V (Cmd+V) to paste.

Limit Selection Size and Use Contiguous Cells

System Limitation: The error 'That command cannot be used on multiple selections' is a confirmed limitation when handling more than a couple of rows or non-adjacent cells in the current version of Microsoft Lists.

Solution 2

Export to Excel for Bulk Copying

If you need to copy and paste large amounts of data, exporting the list to a spreadsheet application circumvents the grid view limitations.

Free Microsoft Office alternative

Manage Your Data Smoothly with WPS Spreadsheet

Tired of limitations when copying and pasting data in Microsoft tools? Switch to WPS Office for a highly compatible, robust spreadsheet experience that easily handles bulk data management without frustrating selection errors.

1. Download WPS Office: Visit the official WPS website to download and install the free WPS Office suite on your device.
2. Open Your Exported Data: Export your Microsoft List to CSV or Excel format, right-click the file, and open it seamlessly in WPS Spreadsheet.
3. Edit Without Restrictions: Select, copy, and paste any number of rows or complex noncontiguous cell ranges without encountering multiple selection errors.

Seamless copy and paste for massive datasets and noncontiguous cells.Fully compatible with Microsoft Excel (.xlsx) formats and exported list data.Lightweight, fast-loading, and entirely free to use.Familiar user interface requires no learning curve.

microsoft office alternative - wps office

Frequently Asked Questions

Why do I get a 'cannot be used on multiple selections' error in Microsoft Lists?

This error typically occurs when you select cells or ranges that are scattered across different rows or columns (noncontiguous). Microsoft Lists Edit grid view requires a strictly continuous block of cells for copy and paste operations.

Is there a limit to how many rows I can copy in Edit grid view?

Yes, users frequently report errors when attempting to copy more than two rows at a time in the Edit grid view. This is considered a backend limitation or defect by Microsoft, forcing users to copy data in much smaller batches.

How can I report this copying limitation to Microsoft?

You can report this defect by navigating to the Microsoft Lists Feedback community portal online. Submit a new feedback ticket detailing the exact number of rows you attempted to copy and the specific error message received.

Document & File Issues